| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stopping the "This removes the subtotal and sorts again." notifica
I am running a macro across multiple tabs where I am removing subtotals.
Prior to the removal of the subtotals for each tab the "This removes the subtotal and sorts again" notification pops-up and the "OK" button must be clicked to proceed. How can I turn off this notification? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stopping the "This removes the subtotal and sorts again." notifica
You could try using Application.DisplayAlerts = False in the macro.
"Hoppy" wrote: I am running a macro across multiple tabs where I am removing subtotals. Prior to the removal of the subtotals for each tab the "This removes the subtotal and sorts again" notification pops-up and the "OK" button must be clicked to proceed. How can I turn off this notification? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
