Macros in a protected sheet

[HughT]

I have a worksheet with a mixture of data entry cells and cells derived from formulas.

I want to protect the formula derived cells so I have locked them and protected the worksheet (no password).

I have various buttons running macros to perform bespoke filters. These are inoperative because the worksheet is protected.

Is there a way to allow the macros to run but still keep the worksheet protected so that users cannot overwrite cells with formulas?

Many thanks

HT

 

[HughT]

No, it appears to be more than one. I set up a dummy worksheet in a new workbook to see if it had the same behaviour and it had, so it may be a general Form Control problem. I am running version 1902 if that is relevant.

 

[Fluff]

That rules out a corrupted workbook.

 

[HughT]

Indeed. Thank you for helping me.

 

[Fluff]

You're welcome