View Single Post
 
Old 01-05-2016, 05:03 AM
iyoossaev iyoossaev is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Dec 2015
Posts: 6
iyoossaev is on a distinguished road
Default

Is there any way to suppress the prompts in the macro that ask if I should continue with irreversible changes?

Edit: I think I actually found the solution to that, leaving it for posteriority with similar problems.
It suffices to add
Code:
Application.Displayalerts = False
at the beginning, and
Code:
Application.Displayalerts = True
at the end to restore the prompts back.

Last edited by iyoossaev; 01-05-2016 at 05:23 AM. Reason: found the solution
Reply With Quote