Hello

I have a workbook, when the user exits the workbook I want
it to hide (using veryhidden) all the worksheets.
When a new user opens the workbook I want to make them
select enable macros or nothing but a blank worksheet will
show.

This all I can do. The problem I face is if I add the hide
worksheets code to the before close event. If a user saves
and then tries to close the book the macro runs and then
excel asks the usual, changes have been made do u want to
save. And so the user has to save again. If I attach the
code to before save, the user may not want to close the
workbook so I don't want the macro to run.

Is there a way around this?

Austin