software

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

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

Thanks for any help

i dont know about 130 sheets but if you hold down ctrl while clicking sheet
tbs you select ALL those sheets and when you edit a particular cell the same
cell on each sheet is changed
--
paul
remove nospam for email addy!
quot;Boysiequot; wrote:

gt; I have a workbook with appoximately 130 worksheets in it. On each sheet one
gt; cell is linked to the quot;masterquot; sheet which lists all of the others. This
gt; sheet is named quot;Wordsquot;. I now need another sheet named quot;Wordsquot; and the
gt; quot;Wordsquot; sheet changed to quot;Mainquot;. Easy at first but all the other sheets are
gt; linked to the quot;Wordsquot; sheet.
gt;
gt; Is it possible to edit the same cell in all of the worksheets at the same?
gt;
gt; Thanks for any help

Paul

Thanks for the info but when I tried it the quot;Edit Hyperlinkquot; option is
greyed out.

It may help if I add it is the same cell on each of the worksheets.

Boysie

quot;paulquot; wrote:

gt; i dont know about 130 sheets but if you hold down ctrl while clicking sheet
gt; tbs you select ALL those sheets and when you edit a particular cell the same
gt; cell on each sheet is changed
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;Boysiequot; wrote:
gt;
gt; gt; I have a workbook with appoximately 130 worksheets in it. On each sheet one
gt; gt; cell is linked to the quot;masterquot; sheet which lists all of the others. This
gt; gt; sheet is named quot;Wordsquot;. I now need another sheet named quot;Wordsquot; and the
gt; gt; quot;Wordsquot; sheet changed to quot;Mainquot;. Easy at first but all the other sheets are
gt; gt; linked to the quot;Wordsquot; sheet.
gt; gt;
gt; gt; Is it possible to edit the same cell in all of the worksheets at the same?
gt; gt;
gt; gt; Thanks for any help

You could use something like this to remove the hyperlinks:

Option Explicit
Sub testme()
Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets
With wks.Range(quot;a1quot;)
If .Hyperlinks.Count gt; 0 Then
.Hyperlinks(1).Delete
End If
End With
Next wks
End Sub

Then instead of using insert|hyperlink to create the hyperlink, you could use
the =hyperlink() worksheet formula:

Group all your sheets that get the hyperlink. (Select the first, and
ctrl-click, or shift-ctrl-click to extend the selection.)

Then select the cell that gets the hyperlink and type this:
=HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,'Words'!A1),quot;click mequot;)

Then rightclick on any of the grouped worksheet tabs and select ungroup sheets.

If you change the name of Words, this =hyperlink() worksheet function will
adjust -- just like any other formula.If you're new to macros, you may want to read David McRitchie's intro at:
www.mvps.org/dmcritchie/excel/getstarted.htmBoysie wrote:
gt;
gt; I have a workbook with appoximately 130 worksheets in it. On each sheet one
gt; cell is linked to the quot;masterquot; sheet which lists all of the others. This
gt; sheet is named quot;Wordsquot;. I now need another sheet named quot;Wordsquot; and the
gt; quot;Wordsquot; sheet changed to quot;Mainquot;. Easy at first but all the other sheets are
gt; linked to the quot;Wordsquot; sheet.
gt;
gt; Is it possible to edit the same cell in all of the worksheets at the same?
gt;
gt; Thanks for any help

--

Dave Peterson

Thanks Dave. Much appreciated. I'll have to digest this and work on it.

Regards

Boysie

quot;Dave Petersonquot; wrote:

gt; You could use something like this to remove the hyperlinks:
gt;
gt; Option Explicit
gt; Sub testme()
gt; Dim wks As Worksheet
gt; For Each wks In ActiveWorkbook.Worksheets
gt; With wks.Range(quot;a1quot;)
gt; If .Hyperlinks.Count gt; 0 Then
gt; .Hyperlinks(1).Delete
gt; End If
gt; End With
gt; Next wks
gt; End Sub
gt;
gt; Then instead of using insert|hyperlink to create the hyperlink, you could use
gt; the =hyperlink() worksheet formula:
gt;
gt; Group all your sheets that get the hyperlink. (Select the first, and
gt; ctrl-click, or shift-ctrl-click to extend the selection.)
gt;
gt; Then select the cell that gets the hyperlink and type this:
gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,'Words'!A1),quot;click mequot;)
gt;
gt; Then rightclick on any of the grouped worksheet tabs and select ungroup sheets.
gt;
gt; If you change the name of Words, this =hyperlink() worksheet function will
gt; adjust -- just like any other formula.
gt;
gt;
gt; If you're new to macros, you may want to read David McRitchie's intro at:
gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt;
gt;
gt; Boysie wrote:
gt; gt;
gt; gt; I have a workbook with appoximately 130 worksheets in it. On each sheet one
gt; gt; cell is linked to the quot;masterquot; sheet which lists all of the others. This
gt; gt; sheet is named quot;Wordsquot;. I now need another sheet named quot;Wordsquot; and the
gt; gt; quot;Wordsquot; sheet changed to quot;Mainquot;. Easy at first but all the other sheets are
gt; gt; linked to the quot;Wordsquot; sheet.
gt; gt;
gt; gt; Is it possible to edit the same cell in all of the worksheets at the same?
gt; gt;
gt; gt; Thanks for any help
gt;
gt; --
gt;
gt; Dave Peterson
gt;