Hi John!

Once more I need your knowledge... sorry about that! :)

Remember the macro you sent me?

Sub Auto_Open()

Application.DisplayFullScreen = True

End Sub


Private Sub Workbook_BeforeClose(Cancel As Boolean)

Application.DisplayFullScreen = False

End Sub

I would like to do the following: when the user opens the file, it opens
in full screen. When he closes the file, the full screen mode turns off.
This two macros works just fine, except for the fact that when the user
clicks on the Cancel button when Excel asks for saving the file, the
full screen turns off and he goes back to the file, with all features
and commands.

My question is: is there a way to let the full screen activated even
when the user clicks on the cancel button in the save window?

Thanks once more!

Raphael

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!