Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
question about worksheet protection using userinterfaceonly:=true
Hi,
I am unable to delete hyperlinks and/or add comments to cells with VBA while my worksheet is protected with the option "userinterfaceonly:=true". Is this by design? I am however able to update cell values with VBA, but not through the UI, so it appears as though it is working to some extent. I see that there is an option named "AllowInsertingHyperlinks" when protecting a sheet, but there is no "AllowDeletingHyperlinks" or "AllowInsertingComments" options. Does this mean that until these options are added I would need to play the uprotect/update sheet/reprotect game? I am aware that you must reprotect a sheet using the "userinterfaceonly:=true" when it is reopened after a save. TIA, Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Protection Question | Excel Discussion (Misc queries) | |||
UserInterfaceOnly & Password Protection | Excel Discussion (Misc queries) | |||
ActiveSheet.Protect UserinterfaceOnly:=true | Excel Programming | |||
Problem with using Protect when userinterfaceonly:=True | Excel Programming | |||
Protection UserInterfaceOnly reading Hidden Formulas | Excel Programming |