ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Qn: Password secure a Menu Bar?? (https://www.excelbanter.com/excel-programming/308866-qn-password-secure-menu-bar.html)

Michael Vaughan

Qn: Password secure a Menu Bar??
 
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[_3_]

Qn: Password secure a Menu Bar??
 
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




Michael Vaughan wrote:

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



All times are GMT +1. The time now is 12:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com