Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
I'm not familiar with macro module.
Where can I find it?
it is under the tools menu - edit module
tried it out, but didn't work.
Thanks though.
any other ideas?
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