Can I run macros on a protected worksheet?

[Mel Smith]

I have a workbook of 6 worksheets and in them are some 76 macros. I have protected each worksheet's cells that contain formulas. The macros I have set up no longer run now that I have set up the protection. Is there a simple way round this?

Mel

 

[MARK858]

I wasn't posting because of the error, I was posting because if the conditions I mentioned are true then you can greatly reduce the number of macro's.