View Single Post
 
Old 02-27-2021, 07:54 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

I'm not sure if this will work.
Step through your code with F8 on the keyboard until the message pops up and make a note of which line caused it, then edit the macro to include the line:
Code:
Application.DisplayAlerts = False
just before it, and later add the line:
Code:
Application.DisplayAlerts = True
to restore it so that future alerts appear as normal (this applies to the user interface messages too, such as when deleting a sheet manually).
Reply With Quote