Protect and Edit Object

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
 
G

GS

(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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sheet Protection / Edit Objects 1
Sheet Protection / Edit Objects 0
Protect Sheet - But have button to add more lines 1
when I protect a worksheet, user cannot use check boxes 4
edit comments in locked cells 0
lock position of Word object in protected excel spreadsheet 1
CheckBox Control Copy and Paste 1
allow a user to edit ranges in a protected worksheet 3

Top