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
Hi Wellie,
Try this... --------------------------------- Private Sub Workbook_Open() ActiveWorkbook.UpdateLinks = xlUpdateLinksNever If Application.UserName = "MyName" Then UpdateLink _ Name:=LinkSources End Sub ---------------------------------- Hope this helps... Chong Moua -----Original 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 to other spreadsheet | Excel Discussion (Misc queries) | |||
2003 update link when Source open | Excel Worksheet Functions | |||
How to disable 'Update alert' when open a spreadsheet has link to other XLS | Excel Programming | |||
How to disable 'Update alert' when open a spreadsheet has link to other XLS | Excel Programming |