View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tiah Tiah is offline
external usenet poster
 
Posts: 3
Default Stopping the "This removes the subtotal and sorts again." notifica

application.DisplayAlerts=False

"Hoppy" a écrit dans le message de news:
...
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?