Sorry. Dont use that use this one
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
Application.EnableEvents = False
Worksheets(5).PrintOut
Application.EnableEvents = True
End Sub
Regards
David Grugeon
On 19 March 2013 22:08, David Grugeon wrote:
> Put this in the ThisWorkb
Put this in the ThisWorkbook module
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Cancel = True
Application.EnableEvents = False
Worksheets(5).PrintOut
End Sub
Regards
David Grugeon
On 19 March 2013 21:50, Shrinivas Shevde wrote:
> Dear All
> I have a excel work book in which there are
,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Shrinivas Shevde
To: excel-macros@googlegroups.com
Sent: Tue, March 19, 2013 7:50:57 AM
Subject: $$Excel-Macros$$ Print problem
Dear All
I have
Hi,
Select *Cal Sheet Page1* ===> View Tab ===> Select Page Break Previow ===>
Adjust One Page Break Lines By Cursor.
Thats It..!!
Regards,
MARIES.
On Sat, Mar 24, 2012 at 11:55 AM, Shankar Bheema wrote:
> Dear experts
>
> When I used to print the attached workbook. The two sheets have to b
In the first sheet, select the area you want to be printed (leaving the
buttons), right click and choose "set print area".
On a difference note Shankar, you might want to keep in mind a simple rule
of this forum which I feel is extremely helpful in all cases. Reproduced
herebelow for ready referen
