| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect/Unprotect Sheets
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protect/Unprotect Sheets
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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect/Unprotect Multiple Sheets With Full Options | Excel Discussion (Misc queries) | |||
| Protect, unprotect | Excel Discussion (Misc queries) | |||
| Protect/unprotect all sheets at once? | New Users to Excel | |||
| Protect-Unprotect all the sheets | Excel Worksheet Functions | |||
| Macros for Protect/Unprotect all sheets in a workbook | Excel Discussion (Misc queries) | |||
![Deeds[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
