open/close Hidden Tab

[JamesArmitage]

I am looking to have a front page that links to hidden tabs (~100) which then hide again when returning back to front page.

I have found the following VBA code online however it give Run Time Error 9 when the hyperlink is more than word (e.g. BestPractice is fine | Best Practice produces error). I have tried _ between the words but that doesn't appear to work either.

If anyone has a solution or a tweak, their help will be greatly apprecaited.

Please Login or Register  to view this content.

[6StringJazzer]

If the parent sheet has a space, then the string will look like

'Best Practice'!

I might try this

Please Login or Register  to view this content.

That will remove the quote marks before using it as a sheet name.

Also, you have undeclared variables, which slows down reading the code and can cause bugs. I strongly recommend to everyone that they declare variables. Doing so prevents a lot of bugs and runtime errors.

[Logit]

.
Apologies for directly addressing your question.

If you are interested ... here are several different methods of accomplishing your goal :

Please Login or Register  to view this content.

[JamesArmitage]

thank you. this works how it brings up an error before opening the sheet 'Reference isn't valid'? Any thoughts or recommendations?

Please Login or Register  to view this content.

[Logit]

.
Strange why it is not working for you. I am running Excel 2007 and your macros work as designed without error.

See attached :

[6StringJazzer]

thank you. this works how it brings up an error before opening the sheet 'Reference isn't valid'? Any thoughts or recommendations?

What is the value of strLinkSheet when this error occurs?

[JamesArmitage]

This is the code as it stands. It still opens the tab but the 'Reference isn't valid' error notification appears. Does this help?

Please Login or Register  to view this content.

[Logit]

.

Please Login or Register  to view this content.

Also NOTE: The link wording MUST be the same as the Sheet Name.