Qn: Password secure a Menu Bar??

[Michael Vaughan]

Hello Everyone,

I think I saw this before, but can't remember where. Is there a way to
secure a menu item on a customized Menu Bar??? So, that when the menu item
is selected, then it prompts for a password. Then only after the password
is properly inserted, then it allows the user to get to that menu???

Thanks.. mv

 

[Dave Peterson]

Maybe you could add a check to each of the procedures called by that toolbar:

dim resp as string
resp = inputbox("password?")
if resp <> "ok" then
msgbox "not for you!"
exit sub
end if