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

Protect Sheet - But have button to add more lines 1
lock position of Word object in protected excel spreadsheet 1
when I protect a worksheet, user cannot use check boxes 4
allow a user to edit ranges in a protected worksheet 3
Excel 2002 "Protect Sheet", but allow "Hide Columns"? 2
To Protect Excel documents and allowing only few cells to edit 1
Excel 2002 "Protect Sheet", but Allow "Insert Comments"? 2
how do I protect a worksheet and still use a checkbox control 4

Top