Hi all,
By default the excel protection is locked when I open new file.
How can I amend such that by default the "locked" box is not ticked?
Thank you.
Hi all,
By default the excel protection is locked when I open new file.
How can I amend such that by default the "locked" box is not ticked?
Thank you.
How about selecting the whole sheet and changing the setting? It's a couple of clicks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I know this option, however I will be performing some automated tasks through VBA on a lot of files. And changing this by default will save a lot of time.
OK, so you should have posted in the VBA section. I am moving this thread there now.
Pretty sure you could record a macro for this.
Hi,
The following Macro should get you started. However, if you are not going to 'Protect' any Sheets, it is not needed.
LewisPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks