ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Password in a combo box (https://www.excelbanter.com/excel-programming/331104-password-combo-box.html)

Angeliki

Password in a combo box
 
Hi all,
I would like to ask you if i could have a password in a combox
in a worksheet. There are many objects and 3 comboboxes in Worksheet 1
but i would like to be the only one with access in one of the three
comboxes.
Can you inform me if this is possible and if yes how can i do that?

Thanks

Regards
Angeliki



Tom Ogilvy

Password in a combo box
 
You could have the combobox hidden and run a macro with an inputbox password
prompt that unhides the combobox.

You could use the selectionchange event to hide it.

--
Regards,
Tom Ogilvy

"Angeliki" wrote in message
...
Hi all,
I would like to ask you if i could have a password in a combox
in a worksheet. There are many objects and 3 comboboxes in Worksheet 1
but i would like to be the only one with access in one of the three
comboxes.
Can you inform me if this is possible and if yes how can i do that?

Thanks

Regards
Angeliki






All times are GMT +1. The time now is 06:26 AM.

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