Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Supress Rows Before Printing - Toolbar Icons become disable
I have used the following Macros from the Discussoion Group in Excel 2007 to
supress printing of Row 1 to 5. Private Sub Workbook_BeforePrint(Cancel As Boolean) ' Hide Row 1 to Row 5 when printing If ActiveSheet.Name = "Adjustment" Then Cancel = True Application.EnableEvents = False Application.ScreenUpdating = False With ActiveSheet .Rows("1:5").EntireRow.Hidden = True .PrintOut .Rows("1:5").EntireRow.Hidden = False End With Application.EnableEvents = True Application.ScreenUpdating = True End If End Sub However, after I clicked "Print Preview", all toolbar icons are disable for selection. I can only get out from pressing the "Esc' key. When I take out the above Macro, selection becomes available. Hope someone can help. Thanks. Igbert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Supress rows | Excel Discussion (Misc queries) | |||
Shortcuts to toolbar icons? | Excel Discussion (Misc queries) | |||
How do I supress printing of text in certain cells of Excel 2003? | Excel Discussion (Misc queries) | |||
Toolbar icons | Setting up and Configuration of Excel | |||
Toolbar icons | Excel Discussion (Misc queries) |