Userforms, selection based on sheet and password

[Guest]

Hi
I know what I want to do but am not quite sure how to tackle the problem. I
have a workbook with twelve sheets (Jan - Dec) with the departmental expenses
downloaded from our main system. I want to generate a userform that a user
can go into, select the month required and the department that they want the
data for, enter a password that checks the password. If password does not
match department, the data is not shown and the file closes. I have done a
listbox for the worksheet data but am not quite sure how to do the listbox
with password security. Any ideas anyone?

 

[Dave Peterson]

You can spend lots of time trying to do this, but if macros are disable, then
the user can easily unprotect your workbook and look at any worksheet in the
workbook.

If you have data that isn't supposed to be seen by other departments, then don't
put it into a workbook that's shared with any other department.