Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling the Update links message
I am trying to automate a process that uses Excel with DDE links & I want to
disable the message that comes up when you open the spreadsheet about "Do you want to update the automatic links etc. Yes/No". I can do this with the Application.AskToUpdateLinks = False in the Activate Event when I run the spreadsheet myself & its visible, but when I try & run the spreadsheet from a script & its invisible to the user, this method doesn't work?? Can I still do this, if so what do I use & what event do I put it in?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling the Update links message
On the menubar
ToolsOptionsEdit See this option :Ask to update automatic links -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "L Buchy" wrote in message ... I am trying to automate a process that uses Excel with DDE links & I want to disable the message that comes up when you open the spreadsheet about "Do you want to update the automatic links etc. Yes/No". I can do this with the Application.AskToUpdateLinks = False in the Activate Event when I run the spreadsheet myself & its visible, but when I try & run the spreadsheet from a script & its invisible to the user, this method doesn't work?? Can I still do this, if so what do I use & what event do I put it in?? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling the Update links message
Application.AskToUpdateLinks = False ' true
-- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "L Buchy" wrote in message ... How do I set this programically?? How & where? "Ron de Bruin" wrote in message ... On the menubar ToolsOptionsEdit See this option :Ask to update automatic links -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "L Buchy" wrote in message ... I am trying to automate a process that uses Excel with DDE links & I want to disable the message that comes up when you open the spreadsheet about "Do you want to update the automatic links etc. Yes/No". I can do this with the Application.AskToUpdateLinks = False in the Activate Event when I run the spreadsheet myself & its visible, but when I try & run the spreadsheet from a script & its invisible to the user, this method doesn't work?? Can I still do this, if so what do I use & what event do I put it in?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot Update Links Message is False but Always Appears | Excel Discussion (Misc queries) | |||
Repost: Disabling Update Links dialog box | Excel Discussion (Misc queries) | |||
Disabling Update Links dialog box | Excel Discussion (Misc queries) | |||
Suppress Update Links Message | Excel Discussion (Misc queries) | |||
Can I avoid annoying Update Links message | Excel Discussion (Misc queries) |