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
Private Sub workbook_open()
un = Application.UserName Select Case un Case "xx1", "xx2", "xx3" ' if user is one of the above the prompt will not be displayed Application.DisplayAlerts = False Case Else Application.DisplayAlerts = True ' prompt will be displayed for other users End Select End Sub -----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) | |||
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 | |||
How to disable 'Update alert' when open a spreadsheet has link to other XLS | Excel Programming |