LinkBack URL
About LinkBacks
I have Worksheet with Hyperlinks to each sheet.In the Sheet Main i have hyperlink are link with Sheets1, sheets2 etc but the problem is when I hidden sheets like sheets1, sheets2 the hyperlink in Main Sheets are not working
I have Worksheet with Hyperlinks to each sheet.In the Sheet Main i have hyperlink are link with Sheets1, sheets2 etc but the problem is when I hidden sheets like sheets1, sheets2 the hyperlink in Main Sheets are not working
That would be correct. Hyperlinks only work with visible sheets, to make the links work you would need to make the sheets visible first.
You can't hyperlink to a hidden sheet
IMHO obvious. If You want to keep them hidden, then instead of standard hyperlink (I think) You have to use VBA to unhide particular sheet first.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Here is the attachment
You will have to remove the hyperlinks for the code to work.
Assign these to your two buttons
Assign this to your return button
Please Login or Register to view this content.
Please Login or Register to view this content.
Until now is working good but still sheets show up visible during use link white VBA, so I hide the sheets but when I use sheets the sheets are unhide agian. I like the sheets to be invisible all the time.
See atatch
Check attached file.
And few words explanation.
Buttons (objects) on Menu tab I renamed as Sheets1 and Sheets2 (as You wish to direct to, and also I cancel hyperlink on it.
Now VBA on Click event checking object name and redirect to particular sheet.
Code as below:
Formula:
Please Login or Register to view this content.
and also I've added on Menu sheet activate hiding both other sheets.
You need to remove the links in the return buttons as well.Originally Posted by bixha
-
-
RemoveLinks.jpg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks