Excel Macros vs. Hidden sheets

[William]

Hello group

I have an application in Excel with several sheets. We want to have a second
version of this for operators but with only half of the sheets of the
original version. The sheets that will be hidden will be the ones doing
calculations. I tried using the hide and password protecting them options so
no one will modify the hidden sheets. The problem is that by doing so, Excel
wont be able to do the calculations and run macros. Any tips on how to hide
sheets that will allow to run and update the macros and the calculation
sheets?

Thanks

William

 

[Bob Greenblatt]

Sure Excel macros and calculations can work with hidden sheets. The problem
probably is that the macros were built with the macro recorder which
generates code to activate sheets. This can be a problem with hidden sheets.
You'll have to update the macros to work properly. If you need more help,
post some samples of the code that is failing and a better description of
what you are trying to do.