VBA Error 400

[jjury75]

I've assigned a macro to a form button to insert a row. It works great until I protect the sheet. Once I protect the sheet and try to button, it gives me an Error Message 400 with no explanation. I have to protect the sheet, as I don't want end users to be able to modify any cells. How do I get the button to work with the sheet protected?

 

[PatOBrien198]

Have the macro un-protect the sheet at the beginning of the macro, then re-protect it at the end.

 

[jjury75]

Have the macro un-protect the sheet at the beginning of the macro, then re-protect it at the end.

Thanks for the reply. Can you tell me how to do that? I'm not very advanced, but am good at finding code in google.

 

[PatOBrien198]

For me, the best way is to record the macro doing what I want to have done, then look at the code and modify as necessary.