Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to disable 'Update alert' when open a spreadsheet has link to other XLS
Sub Auto_Open()
If Application.UserName = "You" then Application.DisplayAlerts = False End if "wellie" wrote in message ... I'd like ONLY to have the 'Update or Don't Update alert window' to be prompted when opening a spreadsheet that has link to other spreadsheets base on who open it. Can someone please show me some code on how to do this ? Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Macro Alert | Excel Discussion (Misc queries) | |||
Update link cells without open up source document files | Excel Worksheet Functions | |||
automatically update a link without opening the other spreadsheet | Excel Discussion (Misc queries) | |||
update link to other spreadsheet | Excel Discussion (Misc queries) | |||
2003 update link when Source open | Excel Worksheet Functions |