Hi

Unprotect the sheet at the top of the macro and then re-protect at the end.

Regards,
Per

"Miree" skrev i meddelelsen
...
I have a work sheet my macro copys data into. When i just protect the
sheet
the macro will not run. Is there a way to lock it so the macro will still
work but the users can not edit the data.

Thank you