[mso] Excel 2003 - can you password protect a whole series of sheets in one go?

Dear all,

I have created a series of up to six workbooks some of which have 10
worksheets in them, which are all inter-connected by formulae. I would like
to be able to protect all the worksheets with the same password by entering
the password twice, as you do normally for each worksheet. Is this possible?

I would also like to be able to clear all the unprotected cells in a
protected worksheet but not those unprotected cells containing a hyperlink!
Is this possible? I have found that cells with hyperlinks in them must be
unprotected to work, is there a way round this?

I guess some of this may be possible using VBA?

TIA for any hints.

-- 
Geoff Culbertson
Petersfield, Hampshire, UK


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: