If i protect a worksheet the macro is not executing. it is giving error
message as
Run-Time Error 1004
You cannot use this command in a protected sheet.

kindly suggest the procedure to execute the macro in a protected sheet. i
want to protect some cells in the sheet from being uptaion.