5 Replies Latest reply: May 24, 2012 10:39 AM by Felim Shanaghy RSS

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

    chris goudy

      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