How do I know from C# code if sheet is protected ?

  • Thread starter Thread starter tusya
  • Start date Start date
from help on ProtectionMode:
True if user-interface-only protection is turned on. To turn on user
interface protection, use the Protect method with the UserInterfaceOnly
argument set to True. Read-only Boolean.

--------

this is the least likely Protection Related attribute to return True since
this form of protection can only be set in code.

You need to check all 4 attribues

ProtectContents
ProtectDrawingObjects
ProtectScenarios
ProtectMod

all worksheet attributes.
 
You must log in or register to reply here.

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

Sheet protection complications 4
Code copies ONLY last j from sheet 9
Returned position address on protected sheet 7
Array code only works on selected sheet 14
Modifying a locked/protected sheet 3
How do you Determine if a Worksheet is protected? 2
Chartobjects protected but it can still be deleted, edited and movedby the user (yes, the sheet is p 5
Spell Checking on a protected sheet 1

Back
Top