Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Right click - Normal view/ Page break preview
The macro below is only working if the activesheet is in "normal
view" but not when in "page break preview" - could someone pls amend the macro to make it works in both status.thxs Sub auto_open() Application.CommandBars("Cell").Reset With Application.CommandBars("Cell").Controls With .Add .Caption = "Close" .OnAction = ThisWorkbook.Name & "!CloseBook" .Tag = cControlTag .BeginGroup = True End With End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to remove page break lines in normal view? | Excel Discussion (Misc queries) | |||
Why does my 100% Normal Page view not match Print Preview? | Excel Discussion (Misc queries) | |||
View in page break preview | Excel Discussion (Misc queries) | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
Page break in normal view set at startup | Excel Discussion (Misc queries) |