| 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 | |||
Hybrid Mode
