Hi, does anyone know how to force excel to remember the settings you select ffor worksheet protection. I need it to allow and remember the right to format cells AND Edit Objects everytime the protection is applied. I have some vba which unlocks all of my worksheets and then relocks all of them. This works just fine, but when the protection is reapplied the Format cells AND edit Objects options are not included.
Code in use is:
Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks