Password Functions

[ColmR]

Hi,

I have recently set up a number of workbooks for people to input specific data. Each workbook requires each person to input the same type of info and they all have their own password. My problem is that every time I run a macro to get information from each workbook I have to input each persons password as I go along. Is there any way I can have a password for myself that will ignore all other passwords?

Thank you,
ColmR

 

[xlbo]

set up an IF statement in code

if environ("username") = "whateveryourusernameis" then
'disable password stuff
else
mPass = inputbox("Please enter your password")
'etc etc
end if

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question