sparky2205
Active Member
- Joined
- Feb 6, 2013
- Messages
- 474
- Office Version
- 365
- 2016
- Platform
- Windows
Hi folks, a very happy Christmas to all.
In the Excel Protection options 'Edit objects' and 'Edit scenarios' options are often selected by default.
This can occur even on previously protected sheets that have been protected with these options deselected.
So, if I protect a worksheet with these options deselected, then at a later stage unprotect the spreadsheet to make some changes then reprotect the worksheet these two options can sometimes be selected without my manual intervention. They are somehow 'auto selected'.
Is there an explanation for this behaviour? And is there some way I can prevent this?
I'm not concerned with the 'Edit scenarios' option, just the 'Edit objects' but as it happens with both I added if for completion.
In the Excel Protection options 'Edit objects' and 'Edit scenarios' options are often selected by default.
This can occur even on previously protected sheets that have been protected with these options deselected.
So, if I protect a worksheet with these options deselected, then at a later stage unprotect the spreadsheet to make some changes then reprotect the worksheet these two options can sometimes be selected without my manual intervention. They are somehow 'auto selected'.
Is there an explanation for this behaviour? And is there some way I can prevent this?
I'm not concerned with the 'Edit scenarios' option, just the 'Edit objects' but as it happens with both I added if for completion.