Forum Discussion

Bronze Contributor

Jun 18, 2018

vba to suppress subtotal prompt

When I used DATA>subtotal to remove all , a prompt (see below) always appears, can I suppress it with vba to default as OK so that it will not show? many thanks

excel

Macros and VBA

Lorenzo Kim

Bronze Contributor

Jul 10, 2018

I found an article to suppress prompt by using:

Application.DisplayAlerts = False

then revert it to True afterwards.

This of course should only be done if all issues have been addressed.

thanks

JKPieterse

Silver Contributor

Jul 10, 2018

I agree, this is a catch-all approach which is not the best way to address the above issue. It *is* useful in some other cases however.

Lorenzo Kim
Bronze Contributor
Jul 10, 2018
thank you