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
You can set the Print Area to the section you wish to print.
This will then print, regardless of what cell is selected.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
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
