Stopping the confirm popup on file save with same name
 

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

Stopping the confirm popup on file save with same name
 

Is this what you are looking for?

Application.DisplayAlerts = False
Application.DisplayAlerts = True

Regards,

OssieMac



"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

Stopping the confirm popup on file save with same name
 

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

Stopping the confirm popup on file save with same name
 

"Tom Ogilvy" wrote:

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

That's it. Thanks!!!

Stopping the confirm popup on file save with same name
 

"OssieMac" wrote:

Is this what you are looking for?

Application.DisplayAlerts = False
Application.DisplayAlerts = True

Regards,

OssieMac



"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


That's it. Thanks!!