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 |
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 |
All times are GMT +1. The time now is 02:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com