| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Record a macro which enters a password to unprotect a workbook
Hi,
Please can someone help. I have a few workbooks that has been protected via Save as\Tools\General options\Password to open. I want to record/edit a macro to open and enter the passwords for all the workbooks, but when I record the macro, it ignore the fact that I am typing in a password, how do I get around this? Many Thanks Zeon. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Record a macro which enters a password to unprotect a workbook
Workbooks.Open Filename:="The Workbook.xls", Password:="ThePassword"
"Zeon" wrote: Hi, Please can someone help. I have a few workbooks that has been protected via Save as\Tools\General options\Password to open. I want to record/edit a macro to open and enter the passwords for all the workbooks, but when I record the macro, it ignore the fact that I am typing in a password, how do I get around this? Many Thanks Zeon. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forgotten Password to Unprotect Workbook/sheet | Excel Discussion (Misc queries) | |||
| I've forgotten the password to unprotect a workbook in Excel. | Excel Worksheet Functions | |||
| How I unprotect my workbook if I failed to remember my password | Excel Worksheet Functions | |||
| How do I unprotect a workbook without the password? | Excel Discussion (Misc queries) | |||
| Unprotect workbook without password | Excel Programming | |||
Linear Mode
