protect sheet disable editing of non empty cell

hi,

i have a code below that unprotect-lock non empty and unlocked cells-protect
but my problem is even after running i can still edit non empty cells
if i do it manually REVIEW->PROTECT SHEET thats the only way i cannot edit anymore non empty cells

Please Login or Register  to view this content.

Hi there,

Try using:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

hi,

tried it i can still edit non empty cells

if you select REVIEW->PROTECT SHEET
the dialog box that appears has a checkbox that says "Protect worksheet and content of locked cells" above where you type your password i think somehow this is not applied when i use my code above

Hi again,

The code I suggested works correctly on my installation, but for a "brute force" approach try using:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

got it to work

my problem was the first code above was saved on the "PERSONAL.XLSB" in a module it was not saved on the actual file i was using
i copied the code to the actual file and put it in the "aftersave" event
saved data are now not editable when protected

just realized this when wondering why it wont work on my end

thanks for the help

Hi again,

Many thanks for this very useful feedback, and also for the Reputation increase - much appreciated

You're very welcome - glad I was able to help.

Best regards,

Greg M