| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening Protected EXCEL worksheets to update linked data | New Users to Excel | |||
| Opening Protected EXCEL worksheets to update linked data | Excel Worksheet Functions | |||
| How do I update data in 3 related files in Excel? | Excel Discussion (Misc queries) | |||
| How do you protect hidden linked worksheets with in an Excel workb | Excel Discussion (Misc queries) | |||
| Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
Hybrid Mode
