hide all sheets when macro is disabled

[cybrkada]

continued from: http://www.excelforum.com/excel-prog...-interval.html

Option Explicit forces explicit declaration of all variables in the code. That is why i had to declare ws as worksheet using the Dim statement before using it in the code. It is recommended to have it - however for this code it wouldn't have mattered.

I'm not sure I exactly follow what you imply here. But yes, you can hide all the sheets at first and then "unhide" at the start of the macro. Let's say you have a "Start" sheet.. then:

Please Login or Register  to view this content.

Please do mark this thread as "Solved". If you have any follow-up queries, kindly raise them via separate thread. You may provide a link to this thread within the new thread to connect them. This way you are likely to receive faster responses from the forum. Cheers!

Please help! The workbook is used by other people too. I cannot just tell them to hide the sheets, it defeats the purpose. What I want is, when macro is disabled, they will only see the START sheet, otherwise, all sheets will be visible. To add to this, a new sheet is added everyday. Sheets name are calendar dates in mmdd format

[JBeaucaire]

Helping create new solutions for new ideas is always fun, but your request is very common and turnkey solutions are found all over the web.

Google: Excel VBA Force Macros Enabled

Any of the top 10 links will most likely serve you instantly. The most thorough solutions are always found on Chip Pearson's site, so watch for that name.

http://www.cpearson.com/excel/EnableMacros.aspx

[cybrkada]

Thanks for the link! I have copied the codes and successfully made it to work except for the cells being unlocked after all the sheets become visible. How do I fix it? Thanks again!

Please Login or Register  to view this content.

[cybrkada]

Sorry i was too fast i forgot to protect the sheet first, my bad! :-(

[JBeaucaire]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.