Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Excel Prompt
I have a workbook with a DDE formula. If the server is
not open when the Excel workbook is opened, Excel displays a message asking if the user wants to start the server application (the dialog reads "Remote data not accessible. Start application 'appname.exe'?"). Application.DisplayAlerts = False does NOT stop this message. Even setting the UpdateRemoteReferences to False for the workbook doesn't stop the message (only after the workbook is opened does this work). Is there an effective way to stop this message from coming up? Thanks, Seth |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Excel Prompt
Use code to open the workbook. the second argument, updatelinks := 0
-- Regards, Tom Ogilvy Seth wrote in message ... I have a workbook with a DDE formula. If the server is not open when the Excel workbook is opened, Excel displays a message asking if the user wants to start the server application (the dialog reads "Remote data not accessible. Start application 'appname.exe'?"). Application.DisplayAlerts = False does NOT stop this message. Even setting the UpdateRemoteReferences to False for the workbook doesn't stop the message (only after the workbook is opened does this work). Is there an effective way to stop this message from coming up? Thanks, Seth |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Excel Prompt
I need to disable "update links" message that pops up when I open a
file manually. In Excel 2002 this is done through Edit/Link configuration. In Excel 2000 however you cannot turn that warning off through the Edit/Link. I've tried using the Workbook.Open (ThisWorkbook), updatelinks:= 0 under the Workbook_Open() sub but can't get it to work. It seems that if you open that file from code, it can be done, but if you open the file manually, I can't get it to ignore update links. FYI - I've also used Application.AsktoUpdateLinks = False and the results are warning messages stating that the links haven't been updated. Thanks for any help!!! Ken *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Excel Prompt
You can toggle the setting (user by user, though) via:
Tools|Options|Edit Tab. There's a checkmark for "ask to update automatic links" But this means that you suppress the question--the links still get updated. This setting is for the individual user--and affects all their workbooks. Ahhh. I bet you tried the updatelinks:=0 in the same workbook that contained the links. Try creating a dummy workbook whose only purpose is to open the original workbook with links not updated: Kind of like: Option Explicit Sub auto_open() Workbooks.Open Filename:="c:\my documents\excel\book2.xls", UpdateLinks:=0 ThisWorkbook.Close savechanges:=False End Sub Then you open the dummy workbook and the links won't be refreshed. Ken K wrote: I need to disable "update links" message that pops up when I open a file manually. In Excel 2002 this is done through Edit/Link configuration. In Excel 2000 however you cannot turn that warning off through the Edit/Link. I've tried using the Workbook.Open (ThisWorkbook), updatelinks:= 0 under the Workbook_Open() sub but can't get it to work. It seems that if you open that file from code, it can be done, but if you open the file manually, I can't get it to ignore update links. FYI - I've also used Application.AsktoUpdateLinks = False and the results are warning messages stating that the links haven't been updated. Thanks for any help!!! Ken *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Allow ActiveX prompt | Excel Discussion (Misc queries) | |||
disable query refresh prompt? | Excel Discussion (Misc queries) | |||
how to disable save prompt on closing excel file in automated mode | Excel Discussion (Misc queries) | |||
How do I disable the ActiveX Control prompt? | Excel Discussion (Misc queries) | |||
Prompt to enable/disable macros | Excel Programming |