| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protected Worksheet Permissions
In 2003, how do you detect what permissions are allowed on a protected
worksheet? The goal is to programmatically unprotect the worksheet, make changes, and then reprotect with the same permissions. But there doesn't seem to be any to detect that. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protected Worksheet Permissions
When you reprotect the worksheet, what permissions are changed from when it was
protected? pearsons_11114 wrote: In 2003, how do you detect what permissions are allowed on a protected worksheet? The goal is to programmatically unprotect the worksheet, make changes, and then reprotect with the same permissions. But there doesn't seem to be any to detect that. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protected Worksheet Permissions
The permission are set to their defaults, rather than what they were set to.
"Dave Peterson" wrote: When you reprotect the worksheet, what permissions are changed from when it was protected? pearsons_11114 wrote: In 2003, how do you detect what permissions are allowed on a protected worksheet? The goal is to programmatically unprotect the worksheet, make changes, and then reprotect with the same permissions. But there doesn't seem to be any to detect that. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protected Worksheet Permissions
You'll have to look at each one individually (or at least the ones you're
interested in): dim wks as worksheet dim myAllowInsertingColumns as boolean set wks = activesheet myinsertingcolumns = wks.Protection.AllowInsertingColumns ..... wks.protect allowinsertingcolumns:=myallowinsertingcolumns pearsons_11114 wrote: The permission are set to their defaults, rather than what they were set to. "Dave Peterson" wrote: When you reprotect the worksheet, what permissions are changed from when it was protected? pearsons_11114 wrote: In 2003, how do you detect what permissions are allowed on a protected worksheet? The goal is to programmatically unprotect the worksheet, make changes, and then reprotect with the same permissions. But there doesn't seem to be any to detect that. -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protected Worksheet Permissions
Bingo, just couldn't find it. "See Also" section is useless. Thanks!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get worksheet change code to work on protected worksheet? | Excel Programming | |||
| Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
| Protected worksheet? | Excel Discussion (Misc queries) | |||
| Manipulate user permissions in a worksheet using VB | Excel Programming | |||
Hybrid Mode
