hyperlinks

  • Thread starter Thread starter Dominique Feteau
  • Start date Start date
D

Dominique Feteau

I have a workbook with many (over 100) sheets. each sheet has 2 hyperlinks
that brings you back to the first Summary sheet. Each of these hyperlinks
are in the same cell (F1 & A17) in each sheet, but they are all wrong
receivng "reference not valid" errors. is there an easy way to change all
of them at the same time instead of going into each sheet and manually
changing each of them?

Dominique
 
Dominique
You can do this by selecting all of the worksheets at the same time. Select your second worksheet. Then, while holding the shift key, select the last worksheet. You should now see [Group] in the line across the top of excel. Now when you fix cell F1 and A17 on the active sheet it will also change the same cells on all of the other selected sheets

Be sure to click on the first sheet to unselect the group before you do anything else

Good Luck
Mark Graesse
(e-mail address removed)

----- Dominique Feteau wrote: ----

I have a workbook with many (over 100) sheets. each sheet has 2 hyperlink
that brings you back to the first Summary sheet. Each of these hyperlink
are in the same cell (F1 & A17) in each sheet, but they are all wron
receivng "reference not valid" errors. is there an easy way to change al
of them at the same time instead of going into each sheet and manuall
changing each of them

Dominiqu
 
Back
Top