Error message when the work sheet is protected with password

[thup_98]

Hello Forum,
I have a workbook with 2 VBA codes. The workbook and the codes work fine until I protect the sheet with password. It stills give me the correct result but as the same time it gives the error:

Run-time error '1004:
Application-defined or object-defined error

How can I remove this error message when the work sheet is protected with password?
Thank you so much for your help
Thup_98

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[InvisibleMan]

Not tested solution, but you are making changes within a Change event handler. You should switch off event handling to avoid looping.

Please Login or Register  to view this content.

[thup_98]

Hi Invisibleman
Thank you for your advice but I cannot make it works. Could you please give more detail?
For temp. solution I format the “NA” & “0”cells to unlocked when worksheet password protected then everything is OK in this case, because the cells value are pulled from data validation functions which store in another password protected tab so the user cannot change the value of the cells, but I think we still can solve this problem through VBA anybody has any idea?
Your help is greatly appreciated.
Thup_98

[InvisibleMan]

'

Please Login or Register  to view this content.

[thup_98]

Brilliant! It works perfectly.
Thank you InvisibleMan
Thup_98

[InvisibleMan]

You're welcome. Thanks for the rep.