Unprotect Range for editing on file open VBA

[pjbassdc]

Hello everyone,

I am wanting to have my project open with cells in a named range "Data_Input", unprotected and available for edit. Everything else on the sheet, I would like to keep locked up. I have been trying various thing I have seen, but the issue is either the whole sheet seem protected, or not at all.
Hopefully someone can get me down the right path.

Currently, this is the little bit of code I have, but it doesn't seem to be doing the trick.

Please Login or Register  to view this content.

Patrick

[Roger Govier]

Hi

Sheet protection is either On for the whole sheet or Off.
The default setting for all cells is Locked, so when you switch protection ON, all cells would be locked.

What you need to do is
Unprotect your sheet.
Select the range of cells where you want Data entry to take place and format the cells>Protection>and remove the check mark from Locked
Then Protect your sheet and just leave it in that state.

You will be able to enter or Amend any entries in the range you have chosen for Data Entry. You will not be able to amend any other cells.

[pjbassdc]

Thank you Roger. It did exactly as I need.



Patrick