Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-24-2011, 01:29 PM
janzen janzen is offline worksheet-name independent hyperlinks Windows XP worksheet-name independent hyperlinks Office 2007
Novice
worksheet-name independent hyperlinks
 
Join Date: Jun 2011
Posts: 1
janzen is on a distinguished road
Default worksheet-name independent hyperlinks

I just found this post on hyperlinks
http://excel.bigresource.com/Track/excel-ClIe789E/



I have a couple questions on that. And was wondering if hopefully somebody would be able to answer them. I really would appreciate if you could help me.

I have a big workbook, with a lot of sheets and every sheet has a number of hyperlinks on it.
1. Now the names of the sheets will change in the future quite often.
2. The hyperlinks that I have in my spreadsheet are linked to certain cells within the same sheet, those cells have been defined with a name. The hyperlinks are linked to that specified name, to prevent the links from failing, when I insert rows or columns
Question: How can I create a hyperlink to those cells, which are defined by a name, so that I don't have to worry about name changes of the sheet?

And here is my second question.

I have cells that are referencing other cells but are supposed to be a hyperlink to a different sheet at the same time. Again that hyperlink has to be independent of the names of the sheets. Is there a possible solution for that? Maybe by using the code name, that you can find in the vb-editor?

I really would appreciate your help. I am stuck on this for a couple days already. Thank you very much.

Jon
Reply With Quote
  #2  
Old 06-27-2011, 01:18 AM
OTPM OTPM is offline worksheet-name independent hyperlinks Windows 7 32bit worksheet-name independent hyperlinks Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Jon
You can do this using VBA. However I am not a VBA expert. May I suggest you re-post your question to say something like:

"I need a VBA routine to check Hyperlinks on Sheet1 that refer to sheets where the name is changed and re-set the hyperlink to the changed name."

I know there are some super VBA people on the forum that will provide this with ease.

Hope this helps.

Tony (OTPM)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
worksheet-name independent hyperlinks Worksheet copying? markg2 Excel 4 01-07-2010 10:08 AM
worksheet-name independent hyperlinks Independent columns jdthelen Word 2 09-17-2009 09:34 PM
Independent tables/filters Wries Excel 0 07-28-2009 04:16 AM
worksheet-name independent hyperlinks independent hyper link execl & word tambal Excel 1 05-20-2009 03:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft