Hi,

I have a pricing tool in development where we use a drop down list to look up prices (from a hidden worksheet within the file) for individual customers my names pulled from a drop down selection. The user selects the customer name in the drop down box then builds the quotation.

I want to limit the selection of each customer name per user. So each time the drop down list is changed, a password is required. Each customer name could have a unique password.

Is it possible to do this with a macro? I have tried to record a macro and assigned a quick access tool button to the macro but it will not change the field. Also, I need to add the steps for required password.

Any help is greatly appreciated.