You really need to be a bit more specific becuase protecting a worksheet
won't stop a macro running but could stop it running as expected. For example
if the macro tried to alter a protected cell an eror would occur.

You could simply un-protect using code as soon as your macro kicked off and
then protect again at the end of the macro.

Sub amacro()
Worksheets("Sheet3").unProtect
'do your stuff
Worksheets("Sheet3").protect
End Sub

Mike

"Steve Eastham" wrote:

I have a two page spreadsheet which has limited # of cells for users to input
data, but then need to run a macro to process the data. With the worksheets
protected, the macro will not run. Does anyone know of any workarounds?

Thanks

Steve Eastham