Is there a way to create a macro that will only work if you type in the
correct password? I have 6 sales guys using a spreadsheet to build sales
orders but would like a macro the sales manager uses to "approve" the order.

Any ideas on how to go about that? I appreciate any help you give in advance.

Thanks

I would just place an InputBox statement at the beginning of the macro
asking for a password. If the password is correct, the remainder of the
macro runs. If not, the macro ends. You can insert a message box if you
wish to tell the user that the password is wrong. You would want to
password protect the code as John suggests. HTH Otto
"Cerberus" wrote in message
...
Is there a way to create a macro that will only work if you type in the
correct password? I have 6 sales guys using a spreadsheet to build sales
orders but would like a macro the sales manager uses to "approve" the
order.

Any ideas on how to go about that? I appreciate any help you give in
advance.

Thanks