Macro Button Error on Protected Sheet

I'm just learning the basics of VBA so keep it "in english" for me!

I need this sheet protected so my team will only edit the necessary fields. I created the following macro and bound it to a button:

Please Login or Register  to view this content.

It works perfectly when Unprotected, but after protecting the sheet I get the error shown below. I have read I could code it to Unprotect > Clear Cells > Protect, but if you give it any level of abuse it could leave the sheet Unprotected. The individuals who will be using these sheets are not very computer literate and are exactly the type of people who would hit the button 20 times if they didn't see the cells clear instantly. Maybe that issue is a myth?

I appreciate the help!

G67EJ4V.png

Good morning mwatson2

Originally Posted by mwatson2

I have read I could code it to Unprotect > Clear Cells > Protect, but if you give it any level of abuse it could leave the sheet Unprotected

I have never heard this, and certainly have no experience of this happening.

Just record your macro, of you unprotecting the sheet, clearing your cells and reprotecting.

Trust me, everthing will be fine!

HTH

DominicB

Found the problem! I had a typo in the range(s) that included a protected cell, I tweaked the code to have the appropriate, unprotected cells and everything worked as intended! (That's the nature of coding I guess!)