Forum Discussion
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
Mr. Pieterse
After making what you suggested, the prompt didn't appear again.
many many thanks
Excellent, glad I could be of help.