Hello, I am having trouble creating a macro that password protects each individual item in my drop-down list. I would like each option in the drop-down to have a unique password to access the data.
This would save me a lot of time in sending out one file to four people versus four different files. Does anyone have a solution to this?
I appreciate any help!!
hi ceceley, you sent a file but i cannot see any dropdown boxes, can you explain a bit more your requirements
scouse13
The dropdown is located in Cell A5. For whatever is chosen from the dropdown in A5, I would like a password to be required contingent on that dropdown. Please let me know if that makes sense.
It makes sense apart from the fact there is not a dropdown box in A5, from your attachment you have 2 sheets, tables and variences, all information looks to be inputted manually with no code to link it? tables lists different departments, and the varience sheet shows data monthly by various means, are you asking for, 1) the user chooses his/her department and can view the data relevant to that department and cannot view another department because that will be protected,2) is all the data for all departments entered on one sheet or will there be a different sheet for each departments data?
I will help you sort it if the above is what you want, but please give as much information as possible of what you would like to achieve
scouse13
Oh I see your question. In my real file, I have data pulling from one large database with nested if statements based on the dropdown's chosen department.
I did not include any of that in the sample file because it is confidential data, and the data itself is really not pertinent to the issue. I have no issue linking the data. I just need to figure out a way to password protect each drop down. In my real file, there is code in all of the data cells. The code links to a "Raw Data" sheet that I export from a database.
I can upload a new sample file if the data part needs to be more similar to my real file.
Hi Ceceley, sorry for the delay in getting back to you, find attached file, hopefully this is what you require.
Scouse13
Sorry for off-topic interjection:
Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.
I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Scouse13,
This is perfect! Thanks so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks