customise button(macro) on toolbar / workbook protection

T

tango

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 Structure:=True, Windows:=False
ActiveWorkbook.Unprotect
 
N

Neil

tango

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

Neil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protect a Workbook 3
Protecting worksheet. 1
Protection Password Prompt Problem 1
Custom Toolbar Add-in 1
Activebook.Unprotect in macro giving errors (Pwd)#2 0
Using Activebook.Unprotect in macro giving errors (Password) 1
macros to hide sheet with protection 1
Problem using VBA for Excel to protect a Workbook with a password. 4

Top