View/Close Hyperlinked Hidden Worksheet

[HaHoBe]

Hi, Xeroku,

there´s really a great way to check if the code does what it´s supposed to do - just save the workbook, add a couple of sheets and test it (sorry of my unclear thoughts but I suggest you to test it, not me ).

If the code works correctly (what I think it will do if the mentioned limitations are considered regarding the names of the 'detail' worksheets) it´s okay otherwise check for the names and find out that they in fact do not match the criteria laid down in the code.

The code may be altered to find the names regarding the sheets to be invisible as well as the name of the summary on a different sheet to make the code more flexible (or just use constants at the beginning of the code instead of variables).

Ciao,
Holger

 

[Rod-b]

I also want to do this, but have a problem!!

Hi, I am also trying to do this (keep sheets hidden but access can be gained by clicking a hyperlink from the "Menu"). I have followed all the advice so far and tried all of the routines but nothing seems to work!! (The routines don't even seem to be running).

I have attached my workbook (with sheets already hidden) in the hope someone may be able to help!! I checked all the hyperlinks before I hid the sheets so I know they work when the sheets are visible. Please note that I have cut down and removed most of the sheets including the raw data for the graphs, but I should have left enough to work with (I have left the routine as is in: This Workbook).

Many thanks,

 

[HaHoBe]

Hi, Rod-b,

I meant another kind of hyperlinks as I have put into the workbook. As you used spaces in Sheetnames I adjusted the code to perform properly for what I call hyperlinks. I put some macros on the autoforms to show an example of how to use these - they actually work well for the first 2 autoforms but refuse to work on the last 2 (I´ll have to check that later if needed).

Ciao,
Holger

 

[Rod-b]

Thanks!

Hi Holger,

Thank you so much for your help! The Macros make sense and I managed to resolve the issue with the last two (I deleted the hyperlink then it worked fine! - I guess it was interfering with the macro)...... Again, thank you so much for your help, I can stop pulling my hair out!

Rod.

 

[Charlie1310]

I would also like to do this but having problems!

Hi There,

I hope you can help me,

I am also trying to get the hyperlinks (which are linked to hidden sheets) on the menu page to show the hidden sheets when the hyperlink is selected but am having real problems in doing so.

I've spent all day on this, tried the examples above, looked at the files which have beed 'fixed' etc and still no joy. I keep getting a run time error '5' stating invalid procedure call or argument.

I would be very very grateful if someone could look at my file and advise me on where I am going wrong? I am a novice to Visual Basic and I am aware I have jumped in the deep end here but I am determined to crack this!

The sheets have been hidden, there is only two (I took the majority of them out). Any advise that can be given will be much appreciated.

Thank you.
Charlie

 

[Shazz]

Can anyone help me please, i have tried everything and It will not work.

I would like to link to all my sheets in the attached workbook and then hide all except Employee data, then when you click on a link or button it goes to the relevent page.

At the moment when I hide the sheets the links do not work.

Please help.

Shazz