Protecting cells problem

[brian.baker13]

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

 

[Dave Peterson]

Maybe you can just add a couple of lines to your macro.

Near the top, unprotect the worksheet
then do your autofilter
then protect your worksheet

 

[brian.baker13]

Maybe you can just add a couple of lines to your macro.

Near the top, unprotect the worksheet
then do your autofilter
then protect your worksheet










--

Dave Peterson- Hide quoted text -

- Show quoted text -

Sorted Dave,
Thanks

Brian