Save Prompt

L

LJuszkiewicz

Excel files I've loaded to web prompts me to save the spreadsheet when I
click on link to defined names within the spreadsheet.

Is there anyway to eliminate the prompts?
 
J

JMB

using VBA - Application.DisplayAlerts = False

I would write the following macro in my personal macro workbook (if need
info on personal macro workbook - I'm sure there are a few threads that go
into detail how to set up)

Sub ToggleAlerts()
Application.DisplayAlerts = Not (Application.DisplayAlerts)

If Application.DisplayAlerts = False Then
Application.StatusBar = "Alerts Are Off"
Else: Application.StatusBar = False
End If

End Sub

and assign it to a new button on my toolbar. then you could toggle Excels
alerts on/off as you wished.
 
Top