Hi

I have a spreadsheet where there is a lot of cells I want locked and
seven columns where Operators input data(one column/day)

I also run an autofilter as a macro when the sheet is opened to look
at non-blanks & also have a macro which clears out the Operator
inputted cells at week start when pressed. These two things won't work
when I have protected cells I get the message Runtime error 1004 you
cannot use this command on a protected sheet.

How can I get around this please?

Thanks

Brian