Full Screen mode and Quitting Excel

[landtimforgot]

My client wants a sales tool I've developed to auto_open in full screen mode. This is fine but, of course, you can't close the workbook directly without either using a keyboard short cut or exiting full screen mode.

Users are most likely to simply quit Excel when they've finished using the tool. But, of course, when they reopen Excel, it's in full screen mode, which will confuse the hell out of the users.

I know that it is possible to run a macro when a workbook is closed (and Excel left open) but is it possible to have a macro in a workbook that runs when the user quits excel?

 

[mikerickson]

The BeforeClose event might be of use.

 

[landtimforgot]

Tried

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayFullScreen = False
End Sub

but no luck.

 

[mikerickson]

Try the Workbook_Deactivate event or the sheet's Deactivate event.

 

[landtimforgot]

Still no joy.

Does quitting Excel stop code triggered by certain events from running?

 

[Jaafar Tribak]

are you using xl 2007 or above ?

 

[landtimforgot]

I use 2007 and 2010, but the client uses 2003 (and I don't have the machine with 2003 on with me right now)