Disable Password Dialog Close Workbook
Hi
I need to open a whole series of workbooks. What i would like to be able to do is if the workbook has a Password (as in File Save As (selecting the Tools Option then Password to Open)), close the workbook immediatley. How do I do this? D |
Disable Password Dialog Close Workbook
You could look at the .haspassword property for that workbook.
But I guess my question is how did you open it if it had a password? David McNaughton wrote: Hi I need to open a whole series of workbooks. What i would like to be able to do is if the workbook has a Password (as in File Save As (selecting the Tools Option then Password to Open)), close the workbook immediatley. How do I do this? D -- Dave Peterson |
All times are GMT +1. The time now is 04:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com