MS Excel 2010: Runtime error 1004

Question

Hi everyone,

I have a vba code. The code runs well. But when I tried to protect sheet, it prompts me runtime error 1004.

I did a google search and in the macro setting, I checked the option "trust access to the VBA project object model".

I also checked the option "enable all macros.

However the error still persisted until I unprotected the worksheet.

My question: how to protect the worksheet and keep the vba code running well?

Thank you,

Ben Lee

Answer 1

Hi,

Look here: https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-protect-excel-vba-sheet-from-editing/fb5b0ff3-8e12-4b13-8f25-4a65b0672cd8

Answer 2

Hi Ronse,

Awesome. The code works perfectly and no more errors.

I was just missing that piece and that excel looked like it was going to fail.

You are indeed truly an expert. 

Thank you very much.

Best Regards,

Ben Lee