| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro button on toolbar | Charts and Charting in Excel | |||
| How do I customise quick access toolbar button images in Excel 200 | Excel Discussion (Misc queries) | |||
| Customise the summation function / button | Excel Worksheet Functions | |||
| how can I customise a toolbar with a tag that holds macros | Charts and Charting in Excel | |||
| Macro Toolbar Button | Excel Programming | |||
Linear Mode
