|
Posted to microsoft.public.excel.programming
|
|
|
Stopping the "This removes the subtotal and sorts again." noti
Thanks for the help!
"Jim Thomlinson" wrote:
This is an application level setting so you must be sure to reset it to True
when you are done. In fact it should really have an error handler on it to
ensure that it gets reset. Something like this (I neglected to add the error
handler in my post).
public sub Whatever()
on error goto ErrorHandler
application.displayalerts = false
'your code here
ErrorHandler:
application.displayalerts = true
end sub
--
HTH...
Jim Thomlinson
"Tiah" wrote:
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?
|