Application.DisplayAlerts = False


Application.DisplayAlerts = True

--
Regards,
Tom Ogilvy


"Chartsmalm" wrote:

I have used this VB excel command before but it was some time ago and I have
forgotten the syntax. I remember that it is a "toggle" . Confirmations are
turned off at the beginning of a macro where you do not want confirms from
the user. Then it is toggled at the end of the macro to put confirmation
back in the normal status.

Help from anyone who recognizes what I'm talking will certainly be
appreciated.

Thanks