Error running Macro when sheet is protected

[tber83]

I am getting an error when I protect a worksheet and save it. Upon re-opening the worksheet, I try to use the cells that are being formatted by a macro, but I get the following error...

Run-time error '1004':

Unable to set the NumberFormat property of the Range Class.


If I open the worksheet and it is already protected from when I last closed it, then I get the error. If I unprotect the sheet, then close it and reopen it, then I don't get the error. Does anyone know what I might be missing or doing wrong. Any help would be great. Thanks!

 

[tbag1122]

I just wanted a button that reset certain cells that i selected on a protected sheet.

This worked perfectly for me on the fist shot.
Many thanks