More complex sheet hiding

[nick2price]

Hi guys. I asked a question earlier about password protecting some sheets. I managed to get this working but found a problem with it. The sheets were only hidden when macros were enabled. So I needed to find a way of making sure macros were enabled before anyone could do anything. So I found this code which works great (I have removed some of the saving functions to shorten it)

Please Login or Register  to view this content.

So now the warning sheet shows on startup, and once macros are enabled, all other sheets show. I had to remove my hidden sheet password code as it didnt work with the above, so now I need a way of getting it back in. When macros are enabled, I need it to display Summary, Filtered Summary and Data Input sheets (not all sheets). Data Input has a button on it which needs code added to it to display the financial sheet if the password is correct.

Is it possible to get that in with this code above?

Cheers

[nick2price]

I have managed to come up with something that seems to work, just want to clarify if it was ok. So I have the code above, and I defined a new constant for the financial sheet. Then at the bottom of the ShowAllSheets function, I added

Please Login or Register  to view this content.

So now when the macro is enabled, it displays all sheets apart from Warning and Financial. So now in my Data Input sheet, I have a button to show all hidden sheets. So I added this code to the button

Please Login or Register  to view this content.

And in ThisWorkbook, I added this function for the above

Please Login or Register  to view this content.

As I say, it seems to work, just want to make sure it is ok? I dont know if my added code interfers in anyway with the original code? I assume this is provided by Excel, xlSheetVisible, so it is this I dont know if I am doing wrong with the new code?

Any advice appreciated

Thanks