Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros to protect worksheet and prevent locked cell selection
The Worksheet.Protect Method has variants such as AllowFiltering, etc., but
doesn't have a variant to define whether users can select locked or unlocked cells. Generally, if a worksheet is mannually protected with "select locked cells" checked, the next protection action using macros will keep this property. However, when the file is open in another computer, the proterty is lost, then users can select locked cells. Thanks to any help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros to protect worksheet and prevent locked cell selection
Further to that, the aim is to prevent users from editing "field settings" in
a PivotTable even the PivotTable is protected, so that hidden items cannot be shown. "Excel Enthusiastic" wrote: The Worksheet.Protect Method has variants such as AllowFiltering, etc., but doesn't have a variant to define whether users can select locked or unlocked cells. Generally, if a worksheet is mannually protected with "select locked cells" checked, the next protection action using macros will keep this property. However, when the file is open in another computer, the proterty is lost, then users can select locked cells. Thanks to any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell selection appears to be locked | Excel Discussion (Misc queries) | |||
cell selection appears locked. How do I unlock it. | Excel Worksheet Functions | |||
how do I prevent users to go into locked cells | Excel Discussion (Misc queries) | |||
how do I prevent users to go into locked cells | Excel Discussion (Misc queries) | |||
Can a cell be locked to prevent being typed over? | Excel Worksheet Functions |