View Single Post
 
Old 01-26-2011, 01:42 PM
tareq tareq is offline Windows 7 Office 2007
Novice
 
Join Date: Sep 2010
Posts: 15
tareq is on a distinguished road
Default

Quote:
Originally Posted by BjornS View Post
Hi,
try this around your macros:

Sub macro xx()
Application.DisplayAlerts = False
(please your existing code here)
Application.DisplayAlerts=True
End sub


You can also place these commands just around the part of the code that creates these kind of messages (how to find them? => Press Alt-F11 to see your macro, place cursor at macro beginning, run the macro "step by step" by pressing F8 over and over again, until you see what code creates this message).

Kind regards
Bjorn
I am very sorry!! It was "Macro2" that make the msg. I will try your solution now. Thanks )
Reply With Quote