Can you add a hyperlink to many worksheets/worgroups at one time?

[Raider]

I am new to this and really need some help. I have created a index page that
list the months with weeks that hyperlink to a workgroup for that week
contaning 5 worksheets for 5 days of the week. At the top of each worksheet
I want to have a cell(Labeled Home) that will hyperlink back to the index
page. Is there a way to add the hyperlink to all the worksheets at one time
or do I have to do it manually on each sheet?

 

[Jim Cone]

You can add a hyperlink to a single sheet, copy that cell,
group all of your other sheets and paste into a cell in the group.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Raider"
wrote in message
I am new to this and really need some help. I have created a index page that
list the months with weeks that hyperlink to a workgroup for that week
contaning 5 worksheets for 5 days of the week. At the top of each worksheet
I want to have a cell(Labeled Home) that will hyperlink back to the index
page. Is there a way to add the hyperlink to all the worksheets at one time
or do I have to do it manually on each sheet?

 

[Raider]

Thanks for the reply
It will take me sometime to copy and paste to each worksheet since I have 51
workbooks that are linked off my index page contaning 5 worksheets each.