Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 12th 05, 10:22 PM
silver beemer
 
Posts: n/a
Default Repairing multiple broken hyperlinks in Excel Spreadsheet

I have limited knowledge of Excel macro writing etc. but have inherited an
Excel spreadsheeet with many hyperlinks to other worksheets on a server. They
are performance management sheets for around 35 staff x 12 (months) plus
quarterly, six monthly and annual) worksheets. Individual results aggregated
to measure team performance etc. Everything working fine, but server is being
relocated shortly and links will break.

No problem to re-build the links using Find and Replace, but every worksheet
is protected so has to be manually unprotected to allow this to happen (Don't
they??). Can anyone please suggest a quicker way of opening and later
closing each worksheet to allow Find and Replace to work? I do not have
access to the person who wrote the original spreadsheets but I do have the
passwords etc. Many thanks.
--
Silver Beemer

  #2   Report Post  
Old September 12th 05, 10:57 PM
Gord Dibben
 
Posts: n/a
Default

silver

Do all the sheets have the same password or are they all unique?

For the former..........

Sub UnprotectAllSheets()
Application.ScreenUpdating = False
Dim n As Single
For n = 1 To Sheets.Count
Sheets(n).Unprotect Password:="justme"
Next n
Application.ScreenUpdating = True
End Sub

If unique password for each sheet, I would suggest you have to unprotect each
one using the unique password.


Gord Dibben Excel MVP

On Mon, 12 Sep 2005 14:22:02 -0700, "silver beemer"
wrote:

I have limited knowledge of Excel macro writing etc. but have inherited an
Excel spreadsheeet with many hyperlinks to other worksheets on a server. They
are performance management sheets for around 35 staff x 12 (months) plus
quarterly, six monthly and annual) worksheets. Individual results aggregated
to measure team performance etc. Everything working fine, but server is being
relocated shortly and links will break.

No problem to re-build the links using Find and Replace, but every worksheet
is protected so has to be manually unprotected to allow this to happen (Don't
they??). Can anyone please suggest a quicker way of opening and later
closing each worksheet to allow Find and Replace to work? I do not have
access to the person who wrote the original spreadsheets but I do have the
passwords etc. Many thanks.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Why do long hyperlinks get truncated on save in Excel? colerb Excel Worksheet Functions 1 June 13th 05 10:37 PM
How do I map multiple XML elements in excel? AStarWithin Excel Discussion (Misc queries) 1 May 3rd 05 01:46 PM
Addressing hyperlinks in excel Owen Dodd Excel Discussion (Misc queries) 1 April 20th 05 08:35 PM
Print multiple excel charts within one sheet to fit to a page lik. lal Excel Discussion (Misc queries) 1 February 18th 05 10:47 PM
Multiple excel users can open the same file and edit at the same . Jeff Howard Excel Discussion (Misc queries) 1 February 18th 05 01:19 PM


All times are GMT +1. The time now is 07:28 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017