You have a couple of options:
- Wrap you code in WS.Unprotect/.Protect statements
- Check out the 5th argument to .Protect .

NickHK

"damiand_1982"
wrote in message
news:damiand_1982.2ci4rt_1155511515.5275@excelforu m-nospam.com...

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


--
damiand_1982
------------------------------------------------------------------------
damiand_1982's Profile:
http://www.excelforum.com/member.php...o&userid=37461
View this thread: http://www.excelforum.com/showthread...hreadid=571224