How to Exit Full Screen when Closing

[Red Bull]

Hello all,

I have a spreadsheet that I would like to display in full screen view when it is opened.
However, when the spreadsheet is closed, Excel remains in full screen view. This will lead to confusion for user's when they open their next spreadsheet and can't see their Excel icons anymore...

Is there a way to change this VBA to display in full screen mode when the spreadsheet is opened, but then when the spreadsheet is closed, to change Excel back to normal view?

Many thanks again!


Private Sub Workbook_Open()

Application.DisplayFullScreen = True

End Sub

 

[Momentman]

You can use a code like this

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

 

[Red Bull]

Worked like a charm! Thanks Momentman.

 

[Momentman]

Worked like a charm! Thanks Momentman.

You are welcome. Thanks for the feedback