Is it possible to unprotect a workbook without opening it?
 

Hi All,

I was accessing workbooks via Ron de Bruin's ADO examples without a hitch.
That is, until I encountered some workbooks that are protected.

Is there any way to unprotect a workbook without opening it?

Any input much appreciated.

Frid

Is it possible to unprotect a workbook without opening it?
 

No, you must open the workbook in order to unprotect it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"FrigidDigit" wrote in message
...
Hi All,

I was accessing workbooks via Ron de Bruin's ADO examples
without a hitch. That is, until I encountered some workbooks
that are protected.

Is there any way to unprotect a workbook without opening it?

Any input much appreciated.

Frid

Is it possible to unprotect a workbook without opening it?
 

Thanks for the quick response Chip!

BTW great site, its helped me a lot!

FD

"Chip Pearson" wrote in message
...
No, you must open the workbook in order to unprotect it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"FrigidDigit" wrote in message
...
Hi All,

I was accessing workbooks via Ron de Bruin's ADO examples without a
hitch. That is, until I encountered some workbooks that are protected.

Is there any way to unprotect a workbook without opening it?

Any input much appreciated.

Frid