brodiemac

Posts: n/a

Edit mulitple hyperlinks

I have about 100 cells that have hyperlinks to another sheet in the workbook.
If I change the name of the destination worksheet, the hyperlinks no longer
work. Is there a way to change the hyperlinks en masse to the name of the
renamed worksheet before I change the name of said worksheet?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
EDIT FORMULA BAR in excel 2003? why not? where is it?	alnav89	Excel Worksheet Functions	2	April 26th 05 07:02 PM
Edit Hyperlinks	yazz22	Excel Worksheet Functions	2	January 15th 05 02:29 PM
How to switch to edit the cell	hon123456	Excel Discussion (Misc queries)	2	January 13th 05 10:40 AM
Can VBA edit hyperlink(s) address	DougM	Excel Discussion (Misc queries)	4	December 16th 04 09:19 PM
Edit Hyperlinks Globally	Rick@Stonybrook	Excel Worksheet Functions	0	November 3rd 04 03:37 PM

All times are GMT +1. The time now is 09:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us