Sheet Protection Properties lost

C

Chris

Hi,

I have a worksheet that is protected with user defined properties (eg. allow
to insert row). To run my VBA I need to unprotect the sheet and reprotect it
with the same user defined protection settings. However the api does not
provide the hooks to get at all these settings! Am I missing something?
 

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

How do you Determine if a Worksheet is protected? 2
Shared Workbooks & Code 1
Returned position address on protected sheet 7
Copying in sheet with protection with the use of a macro 5
Spell Checking on a protected sheet 3
Override protected sheet message? 4
Sheet Protection doesn't hold 0
Protected Cell Problems 2

Top