Hello!
I am trying to develop a workbook, with an index and several tabs. Some tabs should never been shown (the tabs "Stores" and "Cities").
I would like to show only some tabs (the ones with the hyperlink in the index) and they should only be shown once one's clicks on the hyperlink (and once i click in "Back Home", they should be hidden again). I was using the vba code in the excel attached and everything was working perfectly.
The problem is that when I protect the workbook structure (password=123), the hyperlinks stop to work.
Any suggestions of how can I change the code, so I can overcome this difficulty?
Thank you.
Bookmarks