Protected Worksheet Permissions

  • Thread starter Thread starter pearsons_11114
  • Start date Start date
P

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.
 
When you reprotect the worksheet, what permissions are changed from when it was
protected?
 
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
 

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

Controlling worksheet protection via VBA 0
How do you Determine if a Worksheet is protected? 2
Enable autofilter in protected worksheets in Excel 2000 6
How do you trap the worksheet unprotect? 3
Copying in sheet with protection with the use of a macro 5
Finding content of cell in visible "protected" sheets 4
Marco to protect / unprotect worksheet 2
Protection Error 4

Back
Top