Steve, one way is to let the macro unprotect and protect the sheet,
something like this

Const PW As String = "123" 'Change Password Here

ActiveSheet.Unprotect Password:=PW

'you code here

ActiveSheet.Protect Password:=PW



You will also need to protect the VBA project so you can't see the password
in it.

To protect the VBA project, from your workbook right-click the workbook's
icon and pick View Code. This icon is at the top-left of the spreadsheet
this will open the VBA editor, in Project Explorer right click on your
workbook name, if you don't see it press CTRL + r to open the Project
Explorer then select VBA project properties, protection, check lock project
for viewing and set a password. Press Alt and Q to close this window and go
back to your workbook and save and close the file. Be aware that this
password can be broken by third party software


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Steve Eastham" <Steve wrote in message
...
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