Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect and Edit Object
When I protect a worksheet I normally check the Edit Objects box along with other items. More often than not when I unprotect the sheet to edit it and then go to protect it again the Edit Object is automatically unchecked. All my other checked items remained checked. Is there a way of stopping Excel removing the check in the Edit Object box? Stu
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect and Edit Object
explained on 22/11/2012 :
When I protect a worksheet I normally check the Edit Objects box along with other items. More often than not when I unprotect the sheet to edit it and then go to protect it again the Edit Object is automatically unchecked. All my other checked items remained checked. Is there a way of stopping Excel removing the check in the Edit Object box? Stu Some of the protection settings are non-persistent, meaning you must reset them whenever protection is [re]applied. Note that the UserInterfaceOnly setting does not persist between sessions. That parameter needs to be reset every time the file is opened. Note also that to reset protection parameters requires unprotecting beforehand. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i protect edit links ? | Excel Discussion (Misc queries) | |||
protect query from edit | Setting up and Configuration of Excel | |||
how to protect worksheet from edit my query | Excel Discussion (Misc queries) | |||
Way to protect an embedded Object from Edit/deletion but allow RO Access? | Excel Discussion (Misc queries) | |||
Protect Macro from Edit | Excel Programming |