Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide prompt to automatically update links on workbook opening
What is the best way to hide the Window which prompts the
user to choose as to whether to update the links to other workbooks or not on opening the workbook. I do not want all users to update these links i only want 1 user to update the links through the edit menu and nothing else. Thanks in advance. DannySS |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide prompt to automatically update links on workbook opening
Danny, the only way is to have a macro in another workbook or add-in open
the file for the user, and when doing so set update links to false in the open statement. Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "DannySS" wrote in message ... What is the best way to hide the Window which prompts the user to choose as to whether to update the links to other workbooks or not on opening the workbook. I do not want all users to update these links i only want 1 user to update the links through the edit menu and nothing else. Thanks in advance. DannySS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update workbook links without opening all workbooks | Excel Discussion (Misc queries) | |||
Update links without being prompt | Excel Discussion (Misc queries) | |||
Prompt to update links | Links and Linking in Excel | |||
automatically update links without opening file | Excel Worksheet Functions | |||
Don't prompt to Update Links | Excel Programming |