Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn off Excel's 'want to update info?' prompts
Thanks a lot for the hint Tom, didn't know this :) The idea would be, however, that the 'Ask to update links' optio should be turned off automatically regardless of the machine on whic the Workbooks are being opened (the end user may be using anothe machine). That is, i would rather deactivate this option with VBA cod 'exploiting' some event that comes before Excel asks the question abou the updating. I tried the Workbook_Open() private sub (for the 'Workbook open' event and the code: Application.AskToUpdateLinks = False The problem with this one is that Excel first asks to update th links, and THEN the 'Workbook open' event is fired, and the private su above is executed and deactivates the 'Ask to update links' option. Is there any way i can deactivate this option before Excel asks th user to update? Thank you very much for your help :) Ale -- Alex Hatzisava ----------------------------------------------------------------------- Alex Hatzisavas's Profile: http://www.excelforum.com/member.php...fo&userid=1455 View this thread: http://www.excelforum.com/showthread.php?threadid=26812 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn off Excel's 'want to update info?' prompts
No. No code is run before links are updated.
-- Regards, Tom Ogilvy "Alex Hatzisavas" wrote in message ... Thanks a lot for the hint Tom, didn't know this :) The idea would be, however, that the 'Ask to update links' option should be turned off automatically regardless of the machine on which the Workbooks are being opened (the end user may be using another machine). That is, i would rather deactivate this option with VBA code 'exploiting' some event that comes before Excel asks the question about the updating. I tried the Workbook_Open() private sub (for the 'Workbook open' event) and the code: Application.AskToUpdateLinks = False The problem with this one is that Excel first asks to update the links, and THEN the 'Workbook open' event is fired, and the private sub above is executed and deactivates the 'Ask to update links' option. Is there any way i can deactivate this option before Excel asks the user to update? Thank you very much for your help :) Alex -- Alex Hatzisavas ------------------------------------------------------------------------ Alex Hatzisavas's Profile: http://www.excelforum.com/member.php...o&userid=14559 View this thread: http://www.excelforum.com/showthread...hreadid=268123 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off prompts | Excel Discussion (Misc queries) | |||
change info in 1 cell, prompts you for another | Excel Discussion (Misc queries) | |||
Take info on spreadsheet and turn it in a report | Excel Discussion (Misc queries) | |||
How do I turn off info box "This document was sent to the printer. | Excel Discussion (Misc queries) | |||
Turn off Excel's 'want to update info?' prompts | Excel Programming |