View Single Post
  #10  
Old August 7th, 2006, 10:51 AM posted to microsoft.public.excel,microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.setup,microsoft.public.excel.worksheet.functions
doctorjones_md
external usenet poster
 
Posts: 28
Default 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