Protect/Unprotect Sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to write code to 1st unprotect a sheet, then refresh all links, then re-protect the sheet. Everytime it seems to say I can't refresh because the sheet is protected. How can I have it do the above in that order so it unprotects, refreshes, and then protects again?
Thanks
 
This will protect the Active sheet with a password:
ActiveSheet.Protect "mypassword"

This will unprotect the Active sheet with a password:
ActiveSheet.UnProtect "mypassword"

Remove "mypassword" and it will protect/unprotect without a password.

hth
--

steveB

(Remove 'NOSPAM' from email address if contacting me direct)


Deeds said:
I am trying to write code to 1st unprotect a sheet, then refresh all
Click to expand...
links, then re-protect the sheet. Everytime it seems to say I can't refresh
because the sheet is protected. How can I have it do the above in that
order so it unprotects, refreshes, and then protects again?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
How do you Determine if a Worksheet is protected? 2
Protecting worksheet. 1
Copying in sheet with protection with the use of a macro 5
Returned position address on protected sheet 7
Spell Checking on a protected sheet 1
Modifying a locked/protected sheet 3
Multiple sheet unprotection not working 9

Back
Top