How do I? Get Excel to do something when I close a workbook

  • Thread starter Thread starter emu_tails
  • Start date Start date
E

emu_tails

I'm trying to write two seperate macros to make changes to a workbook
when I open it and close it.

When I open the workbook I want to go to fullscreen - which I've
managed to do. However!

When I close the workbook I want to cancel the fullscreen option.

I've tried several things including the WorkBookBeforeClose sub. I can
get Excel to make the changes when I write and run a macro to close the
workbook. But when I use the Close function in the File menu, Excel
stays in fullscreen mode!! Quite frustrating!

Can anyone help??

Many thanks.

Andrew.
 
Place this events in the Thisworkbook mudule

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

Private Sub Workbook_Open()
Application.DisplayFullScreen = True
End Sub
 
Thanks for the help!!

I've put the VB into the right module. However, if I say try writing a
macro to close the workbook (ThisWorkbook.Close) then the fullscreen
won't change?

Any ideas?
 
Back
Top