Results 21 to 34 of 34

Thread: Two macro button but in a double action

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #31
    VBAX Expert
    Joined
    Oct 2012
    Posts
    726
    Location
    The first parameter of hide and unhide is the password.
    For unhide you enter the password via the input box.
    For hide it is hard coded. In the code I posted above the password is Plovdiv. Which is also a sheet name so I think you are confusing the two.

    so you should change this line

    If Hide("Plovdiv", "London", "NY", "Paris") Then

    to

    If Hide("whatever your password is", "Plovdiv", "London", "NY", "Paris") Then

    ++edit

    basically for both, it's password and then the list of sheet names. (I've no idea why I used Plovdid as password)
    Last edited by jonh; 09-19-2014 at 02:52 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •