View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Boysie
 
Posts: n/a
Default How can I edit a hyperlink in more than one cell at once

I have a workbook with appoximately 130 worksheets in it. On each sheet one
cell is linked to the "master" sheet which lists all of the others. This
sheet is named "Words". I now need another sheet named "Words" and the
"Words" sheet changed to "Main". Easy at first but all the other sheets are
linked to the "Words" sheet.

Is it possible to edit the same cell in all of the worksheets at the same?

Thanks for any help