Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I know from C# code if sheet is protected ?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I know from C# code if sheet is protected ?
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. -- Regards, Tom Ogilvy "Inbar" wrote in message ... Check the boolean Worksheet.ProtectionMode to find out... "tusya " wrote: How do I know from C# code if sheet is protected ? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code and protected cells | Excel Discussion (Misc queries) | |||
Code fails when sheet is protected | Excel Discussion (Misc queries) | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
Checking with code to see if a Workbook is Protected? | Excel Programming | |||
Unwanted Protected Code | Excel Programming |