customise button(macro) on toolbar / workbook protection
 

dear all,
1)
is there a way for button 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?

2)
i have the following statement in my script and they work nicely. but
i do not understand why under tools menu, protection, unprotect
workbook not ask for password to unprotect. i scared later on user
will find out this.

ActiveWorkbook.Protect Structu=True, Windows:=False
ActiveWorkbook.Unprotect

customise button(macro) on toolbar / workbook protection
 

tango

ActiveWorkbook.Protect "Your Password",Structu=True, Windows:=False
ActiveWorkbook.Unprotect "Your Password"

Neil

"tango" wrote in message
m...
dear all,
1)
is there a way for button 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?

2)
i have the following statement in my script and they work nicely. but
i do not understand why under tools menu, protection, unprotect
workbook not ask for password to unprotect. i scared later on user
will find out this.

ActiveWorkbook.Protect Structu=True, Windows:=False
ActiveWorkbook.Unprotect