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