Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable update links prompt
I have been searching through posts and cannot find
a consistent answer to this question. I am running Excel 2003 and I would like to remove or disable the "update links" prompt when the file is open. I have gone to Edit - Links - Start-up Prompt - and checked: "Don't display the alert and update links" which is exactly what I want to happen when the file is opened by any of my multiple users, however the alert comes up anyway. Does anyone have any advise as to how to disable this prompt? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable update links prompt
On the menu bar, ToolsOptionsEdit tabUncheck "Ask to Update Links"
"Opal" wrote: I have been searching through posts and cannot find a consistent answer to this question. I am running Excel 2003 and I would like to remove or disable the "update links" prompt when the file is open. I have gone to Edit - Links - Start-up Prompt - and checked: "Don't display the alert and update links" which is exactly what I want to happen when the file is opened by any of my multiple users, however the alert comes up anyway. Does anyone have any advise as to how to disable this prompt? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable update links prompt
That setting is for your system only. It would not affect another user's
system. They would have to adjust their own systems to disable the message. "Opal" wrote: I have been searching through posts and cannot find a consistent answer to this question. I am running Excel 2003 and I would like to remove or disable the "update links" prompt when the file is open. I have gone to Edit - Links - Start-up Prompt - and checked: "Don't display the alert and update links" which is exactly what I want to happen when the file is opened by any of my multiple users, however the alert comes up anyway. Does anyone have any advise as to how to disable this prompt? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable update links prompt
You could, however, put a line in the Workbook.Open event like:
Application.AskToUpdateLinks = False which would turn it off for them. "Opal" wrote: I have been searching through posts and cannot find a consistent answer to this question. I am running Excel 2003 and I would like to remove or disable the "update links" prompt when the file is open. I have gone to Edit - Links - Start-up Prompt - and checked: "Don't display the alert and update links" which is exactly what I want to happen when the file is opened by any of my multiple users, however the alert comes up anyway. Does anyone have any advise as to how to disable this prompt? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable update links prompt
Put this in the ThisWorkbook code module. In the VBE Project Window, right click ThisWorkbook and choose view code. Copy and paste this into that code window. If you already have a Workbook Open event code, then just add the middle line of this code into the existing code. Private Sub Workbook_Open() Application.AskToUpdateLinks = False End sub "JLGWhiz" wrote: You could, however, put a line in the Workbook.Open event like: Application.AskToUpdateLinks = False which would turn it off for them. "Opal" wrote: I have been searching through posts and cannot find a consistent answer to this question. I am running Excel 2003 and I would like to remove or disable the "update links" prompt when the file is open. I have gone to Edit - Links - Start-up Prompt - and checked: "Don't display the alert and update links" which is exactly what I want to happen when the file is opened by any of my multiple users, however the alert comes up anyway. Does anyone have any advise as to how to disable this prompt? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable update links prompt
Thank you JLGWhiz,
That last post was exactly what I needed. I couldn't use the Tools -Options....as I have over 100 people accessing this file and we need the prompt working for other files, so I needed this to work on this file only. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update links without being prompt | Excel Discussion (Misc queries) | |||
Update Links - no prompt | Excel Programming | |||
Need to disable a prompt in Excel when trying to programatically update links in a PPT Presentation that is linked to Excel | Excel Programming | |||
Prompt to update links | Links and Linking in Excel | |||
Don't prompt to Update Links | Excel Programming |