| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!!! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dont confirm save with yes/no/cancell | Excel Programming | |||
| Stopping spreadsheet save | New Users to Excel | |||
| After Save Event - Confirm | Excel Programming | |||
| Disable Save Workbook popup | Excel Programming | |||
| Saveing a file (Confirm Replace) | Excel Programming | |||
![Chartsmalm[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
