buttons that change sheets don't work when 'show all sheets' unticked under security

[Anonymous]

My buttons work when 'show all sheets' under security is ticked, but not when it is ticked.

any ideas?

I have conditional vDisplay=() on each sheets general property page

I have given each button the following actions

Activate Sheet

     SheetID = SH()

Set Variable   

     Variable =vDisplay

     Value = ()

and I checked to make sure all the values match up

[#2]

It may sound odd but have you checked your Macro module has Current Local Security set to Allow System Access, I have experienced issues with this in the past

[Anonymous]

I'm not familiar with macro module.

Where can I find it?

[#4]

it is under the tools menu - edit module

[Anonymous]

tried it out, but didn't work.

Thanks though.

any other ideas?

[#6]

I think I understand what you are trying to do and thinking back to my certification I found issues with the script running when you swapped from one sheet to another and ended up just showing and hiding the tabs and letting the user select the tab