Opening Protected EXCEL worksheets to update linked data
Bill,
Thanks for your keen eye -- works like a charm, except for the problem that
the Finance Folks have varying passwords on individual worksheets -- they'll
need to get together and decide on a universal (shared) password, but other
than that, the code works great.
Thanks again for your help.
==================================
"Bill Manville" wrote in message
...
should be
Workbooks.Open
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|