LinkBack URL
About LinkBacks
I want to place a HL into every worksheet that takes them back to my TOC, but I have 75+ sheets
I want to place a HL into every worksheet that takes them back to my TOC, but I have 75+ sheets
- Click on the first tab that you want to create a hyperlink
- Shift+Click on the last tab you want to create a hyperlink
(This will select all tabs in between)- Select the cell that should have a hyperlink and insert this formula
=HYPERLINK("#Sheet1!A1","TOC")- Change Sheet1 to the TOC sheet name.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
So this will create a link to each of the 75 sheets independently?
Yep. .
............
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks