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
Thank you for your suggestion.
many thanks
Thank you for your suggestion.
many thanks
Did the suggestion work?
Mr. Pieterse
After making what you suggested, the prompt didn't appear again.
many many thanks
- Excellent, glad I could be of help.