Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Elliott Jones   on Sep 19 In MS Office Category.

  
Question Answered By: Tarron Thompson   on Sep 19

it's better to create a VBA that "looks" into the cell and leaves
you to the hidden  sheet (unhiding it before).

I have a sheet  here where I created a menu like this. The old guys made a harder
solution, with ComboBox and white/hidden cells... so I tried hyperlinks, but
with hyperlinks I have noticied that my users was not able to update the menu
when needed. So, my solution was made this VBA. Users can create new sheets  and
the only work is add a new line on this simple menu.

And about the original solution, I keep only the "hide others" feature, but
changing the "For 2 to XX" to "For 2 to Sheets.Count", thinking on a error-free
solution when the user add more sheets.

Share: 

 

This Question has 5 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Hyperlink to a hidden sheet Or get search suggestion and latest updates.


Tagged: