A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Repairing multiple broken hyperlinks in Excel Spreadsheet



 
 
Thread Tools Display Modes
  #1  
Old September 12th 05, 10:22 PM
silver beemer
external usenet poster
 
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
Ads
  #2  
Old September 12th 05, 10:57 PM
Gord Dibben
external usenet poster
 
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.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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:08 AM.


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