Quote Originally Posted by Andy Pope View Post
Without details we have no idea what you mean by "distorts the running vba codes"

As I said if the sheet is protected you will need to unprotect it whilst the code in running and reapply it when finished.
The macro recorder will provide code need.
Hello Andy Pope!!!

Thanks for your response... Here is my worksheet which I'm working on... As you can see, the worksheet already has VBA codes which is working properly as I wanted it to be.. However, every time I lock the columns J, O, P and Q via putting on a "protected worksheet" status... and then I use the "Hide" and/or the "Reset" Button I made for the VBA Codes, Excel prompts me with "Error 400"...

Grading Sheet.xlsm

I wanted these columns J, O, P and Q to be locked so that my other colleagues won't be able to accidentally change the values inside it.

/The Macros have a password, it is "09193483966"/

Thank you very much!