Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Avoid Startup Prompt on Excel 2002
Hello,
On excel worksheet I've got many links to other files and everytime I open my file I get a msgbox asking to wheter I want to update or not. Is it possible to avoid that message thru vba (I know that If I go to Edit-Links-Startup Prompt I can remove this message) ? Thanks in advance. Cheers Nader |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Avoid Startup Prompt on Excel 2002
You can certainly make that setting using VBA.
ActiveWorkbook.UpdateLinks = xlUpdateLinksNever or pick the specific value you want. However, it will not affect the file that contains the code (except in versions earlier than xl2003, it will probably produce an error). The prompt is performed before any macros are run. This is true for any other link related setting as well. This is a setting specific to and stored with the workbook although it was introduced in xl2003, so it would have no affect in earlier versions as appears to be your problem. In earlier versions than xl2003, the usual suggestion is to have two workbooks. the User opens the "dummy" workbook which uses code to open the actual workbook with the command specified to handle links as you want, then closes itself. -- Regards, Tom Ogilvy "Nader" wrote: Hello, On excel worksheet I've got many links to other files and everytime I open my file I get a msgbox asking to wheter I want to update or not. Is it possible to avoid that message thru vba (I know that If I go to Edit-Links-Startup Prompt I can remove this message) ? Thanks in advance. Cheers Nader |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: How to avoid pasting blanks ? | Excel Discussion (Misc queries) | |||
Excel 2003 VBA Prompt on Startup | Setting up and Configuration of Excel | |||
How to avoid "update links" startup prompt? | Excel Discussion (Misc queries) | |||
Excel 2002 Startup Macro | Excel Programming | |||
Excel 2002 and startup | Excel Programming |