G'day guys,

I have an excel worksheet with protection to mainly hide formulas and prevent users from accidentally deleting/modifying the formulas.

I have created a couple of macro's to reset a filter on a collum and reset the wrap text function on the sheet, however, when I go to execute the macro the sheet come up with an error due to it being protected.

Does anyone know how I can keep the sheet protected (or at least the formulas hidden) and still have the Macros?

Any help would be appreciated.

Cheers
Damian