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

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@googlemail.com" wrote:
>
> 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

On Nov 27, 3:42 pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> 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.bake...@googlemail.com" wrote:
>
> > 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- Hide quoted text -
>
> - Show quoted text -

Sorted Dave,
Thanks

Brian