Protect and Edit Object

  • Thread starter Thread starter sandjclarke
  • Start date Start date
S

sandjclarke

When I protect a worksheet I normally check the Edit Objects box along withother items. More often than not when I unprotect the sheet to edit it andthen go to protect it again the Edit Object is automatically unchecked. All my other checked items remained checked. Is there a way of stopping Excelremoving the check in the Edit Object box? Stu
 
(e-mail address removed) 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
Click to expand...

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
 
Back
Top