Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Suppress confirmation messages in excel 1
- Thread starter Mack2
- Start date
-
1
- #2
AnotherHiggins
Technical User
wrap the offending lines of code with this:
Application.DisplayAlerts = false
'Your code
Application.DisplayAlerts = true
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ181-2886 before posting.
Application.DisplayAlerts = false
'Your code
Application.DisplayAlerts = true
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ181-2886 before posting.
- Thread starter
- #3
AnotherHiggins
Technical User
Happy to have helped!
![[cheers]](/data/assets/smilies/cheers.gif "[cheers] [cheers]")
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ181-2886 before posting.
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ181-2886 before posting.
- Status
Similar threads
- Locked
- Solved
- Locked
- Question
- Locked
- Question