Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Write Error Trap
I have the following code to toggle between print preview and normal
view but I need to add an error statement just in case there is no sheet open. Can someone please suggest how I might write this. Thanks Sub TogglePrintView() If ActiveWindow.View = xlPageBreakPreview Then ActiveWindow.View = xlNormalView ElseIf ActiveWindow.View = xlNormalView Then ActiveWindow.View = xlPageBreakPreview End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Write Error Trap | Excel Programming | |||
Set Error handling INSIDE error-trap | Excel Programming | |||
Need error trap | Excel Programming | |||
Error Handling - On Error GoTo doesn't trap error successfully | Excel Programming | |||
Error Trap | Excel Programming |