Just under the start of the Sub:
Application.DisplayAlerts = False

Just before the end of the Sub
Application.DisplayAlerts = True

Regards,
Ryan---

--
RyGuy


"MikeM" wrote:

I have a Macro that takes current subtotal in a range and removes them.
However, the Macro Stop and gives me a Message Box telling me that "Entire
SubTotal will be deleted" Choice of OK or Cancel. How can I have it not ask
me this and just automatically run remove the SubTotal?
The line simple reads as follows:

Selection.RemoveSubtotal
Range("F8:AA321").Select
--
MJM