| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I enter a workbook password automatically
Hi
I have a set of 6 user workbooks each of which is uniquely passworded (one worksheet in each). I then have a "master" workbook, which is also uniquely passworded, that links to each of the 6 user workbooks to gather the worksheet information into one place. When the master is opened, Excel asks for the master password (which is fine) but it also then asks for each of the 6 user workbook passwords. Can I code the 6 usere workbook passwords into the master to save entering them everytime? Perhaps by macro or something? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Password Protect - put password in a cell in the workbook | Excel Programming | |||
| Automatically enter password | Excel Programming | |||
| Automatically enter Password in Macro | Excel Programming | |||
| Please need HELP - Need to add and INPUT BOX so that users need to enter a PASSWORD to use a workbook | Excel Programming | |||
| one line macro to enter password for workbook | Excel Programming | |||
Threaded Mode
