ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Password on Commandbar menu list (https://www.excelbanter.com/excel-programming/338097-password-commandbar-menu-list.html)

JB2005

Password on Commandbar menu list
 
I would like to include and "ADMIN" menu list in a custom commandbar, with
password control.

The idea is; once this list is selected and password contol is passed, all
"ADMIN" functions on the list become available.

Any ideas how this may be achieved?

Many thanks.

bigwheel

Password on Commandbar menu list
 
I would think that this could be achieved by setting up your menu and have
the properties of all but one item set to Enabled=False. Then when the
enabled item is
clicked it runs a macro to check the password and, if correct, enables all
the other menu options. See the help file on the Enabled Property for a few
hints.

"JB2005" wrote:

I would like to include and "ADMIN" menu list in a custom commandbar, with
password control.

The idea is; once this list is selected and password contol is passed, all
"ADMIN" functions on the list become available.

Any ideas how this may be achieved?

Many thanks.


JB2005

Password on Commandbar menu list
 
Cheers bigwheel.

That's one way - I will play with this concept.

Many thanks.

"bigwheel" wrote:

I would think that this could be achieved by setting up your menu and have
the properties of all but one item set to Enabled=False. Then when the
enabled item is
clicked it runs a macro to check the password and, if correct, enables all
the other menu options. See the help file on the Enabled Property for a few
hints.

"JB2005" wrote:

I would like to include and "ADMIN" menu list in a custom commandbar, with
password control.

The idea is; once this list is selected and password contol is passed, all
"ADMIN" functions on the list become available.

Any ideas how this may be achieved?

Many thanks.



All times are GMT +1. The time now is 05:36 PM.

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