enable /disable customised button on toolbar

[Guest]

Dear All,
Is there a way for customised button(macro) to appear on toolbar only when
user provide password? i got 1 button on worksheet whereby if user enter
correct
password then button will be shown on toolbar.
can?
Please have yr advice.

Thanks alot

 

[Myrna Larson]

Have your macro create the button and put it on the toolbar only if the
password is correct. Delete it when the workbook is closed. You would use the
Workbook_OPen and Workbook_BeforeClose events for these things.

 

[Guest]

how the scripts like? can i put in 1 of the event (not workbook open) to
enable and disable can put in workbook before close. i cannot put in workbook
open as not all user can use the button on the toolbar.
or another way is in order to use the customised button, user must provide
password when click on the customised button. then in this case i can put in
the toolbar all the time. but how the script like?

which is simpler?
thanks alot