Put your 'hiding' routine in the 'ThisWorkbook' 'BeforeClose' section.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"ccarmock" wrote:


I have an Excel 2003 Application taht uses Excel Macros to protect cells
within the sheet as data is entered. This is working well so far.

Before saving it I have a Macro I run to hide all the useful sheets and
then Auto_Run is set to unhide them again. Thus if Macros are
disabled whent he sheet is opened, Auto_Run won't run and the sheets
won't be accessible.

The problem I have is that I, currently, have no way to prevent a user
saving the sheet with all tabs visible and then reopening with Macros
disabled, and then the Macros that run when data is entered do not run
either.

One way round this would be to force a Macro to run when the sheet is
saved, which could rehide the appropriate sheets again. Alternatively
if the normal System Save can be disabled I coudl then force the user
to save via a Macro attached to a button.

Does anyone have any ideas that could help here?

Regards
CLive


--
ccarmock
------------------------------------------------------------------------
ccarmock's Profile: http://www.excelforum.com/member.php...o&userid=27670
View this thread: http://www.excelforum.com/showthread...hreadid=472333