Protected Worksheet Permissions

[pearsons_11114]

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]

When you reprotect the worksheet, what permissions are changed from when it was
protected?

 

[pearsons_11114]

The permission are set to their defaults, rather than what they were set to.

 

[Dave Peterson]

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]

Bingo, just couldn't find it. "See Also" section is useless. Thanks!