How can I "make default" the options proposed when I protect sheet ?

Anonymous
2018-07-06T08:13:51+00:00

Because it is boring and especially unproductive to check and check again and again boxes each time I protect the sheet before saving it...on sometimes 30 files a day. And forgoting to recheck the boxes that have to be checked.

Check, check, check boxes, hum.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2018-07-06T15:40:12+00:00

Hi Claude De Marchi,

If "the options proposed when I protect sheet" is the options showing in the dialog below, by default Select locked cells and Select unlocked cells are checked. If you want to check other options and set them as default options when you protect new sheet,  we'd like to explain that there is no out of box feature in Excel to achieve this.

We welcome and suggest you send feedback to Excel UserVoice, this is the best way to let the related team know your ideas and make our products better for your and others. Thanks for your understanding.

Community members who have the same experience and have Macro solutions are welcome to share insights here.

Regards,

Tina

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more