Hiding a specific worksheet on close

[SeliM]

I have an advanced analysis WS that users can access via a macro.
I am trying to use a "WORKBOOK_BEFOReCLOSE(Cancel As Boolean)" solution on this site.
For syntax reasons I cannot get it to function at all.

The task: When a user accesses the "Advanced Analysis" sheet via macro to have the "Advanced Analysis" WS return to hidden on file closed.

Many thanks for your help in the past as well as ahead.

M

 

[Armstrong_N14]

Hope this helps:

How to Run a Macro Automatically Before Workbook Close in Excel

To run a macro automatically before the workbook closes down, use the workbook_close event. This is the simplest way to run a specific macro when a specific workbook closes.

www.exceltip.com

 

[SeliM]

Thank you, it does and it works (because I now have the code in the right place)

Apologies for not locating the solution when searching earlier.

M