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

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