LIST BOX PLEASE HELP

chefwarren

Board Regular
Joined
May 9, 2007
Messages
127
Hi All,

I have more questions.

Can the list in a drop down box be changed based on the input of another drop down box.

example

Cell B1
Drop down list box containing list of sales people. (THIS PART I CAN DO)

warren
gina
mike
joe

Cell B2
Drop down list box containing customers of sales person specific to the person selected in B1. (NEED HELP HERE)

Then

Can B1 be password protected so only Gina can view her customers etc. (NEED HELP HERE TOO)

Sorry for the repost. Just no one seems to be able to answer this one.

Warren
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

chefwarren

Board Regular
Joined
May 9, 2007
Messages
127
Thank you so much for your response. i couldnt find the answer anywhere on here.

how about my second question.

Can the selections be password protected.

That is to say.

I want to email this master file to all my sales team. But I dont want Gina to see what warren is doing etc.

So when Gina opens the file, and selects her name from the list it asks her for a specific password associated with her name.

and so on and so on for each of the sales people.
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Sorry for the repost. Just no one seems to be able to answer this one.

Next time just bump your original post (which I have since locked). Multiple threads on the same topic can make things confusing. ;)

Smitty
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
If you'll notice, we posted at the same time, so I didn't see your question until now.

You could password protect using a select case argument in the Worbook_Open event, but if you're going that far why not just load each user's information when you open it based on their login name, which you can get with Environ("username"). That way they don't have to remember additonal passwords and you're streamlining the process for them.

Smitty
 

Watch MrExcel Video

Forum statistics

Threads
1,122,514
Messages
5,596,610
Members
414,080
Latest member
penguin23

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top