Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unprotect workbook | Excel Discussion (Misc queries) | |||
unprotect workbook | Excel Discussion (Misc queries) | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
Unprotect workbook | Excel Programming | |||
Unprotect a Workbook | Excel Programming |