Closing WB with a timer no changing sheets to very hidden

Hi Guys,

I have this code in my "This workbook"

Please Login or Register  to view this content.

This changes all sheets from very hidden to visible and when closing back to very hidden again. This stops sheets from being visible if there is a macro error when the sheet is starting up. This works perfect.

I also have a timer set up that if there is no activity in 10 minutes the workbook auto closes. When this happens the sheets do not change to very hidden therefore and macro errors going forward display all sheets which I really do not want.

Please Login or Register  to view this content.

I'm assuming I also need a "change all sheets to very hidden on close" code in the timer section but not sure how I would go about that.

I have manually set all sheets bar Splash to very hidden. If you close this with the x on top and try to open the spreadsheet with macros on high you get a warning with only the splash sheet visible. If the timer runs out (for this example I have set the timer at 1 min)and the sheet closes and you reopen with macros set to high you get the same warning message but all sheets are visible and accessible. Although I am aware that Excel is not secure I am more worried about someone stumbling across this information as opposed to being malicious. I have attached the spreadsheet. If you select user name: John and password: Test

Thank you

Thanks for the reply guys,

I'm not great at code. I've been helped with everything I've done so far. Where do I put this extra code. I assumed it was in the timer module which I did below but this didn't rehide the sheets when the timer ran out.

Please Login or Register  to view this content.

I have also tried it in "This Workbook"section but again didn't work although I expect I've put it in wrong

Please Login or Register  to view this content.

Hi Kevin,

Thanks a mil for your patience. I think I have it working with your first part of code.

Please Login or Register  to view this content.

The second part seems to be causing errors. Do I require this second part for any reason? Sheets are already programmed to unhide depending on who logs in. Your bit ensures all sheets return to hidden when timer runs out. I just want to make sure I'm not leaving myself open by leaving the second part out.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi Kevin,

Have that working perfectly. Thanks a million for your help.