Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Force Response in Dialog Box
Is there a way to force the response in a dialog box
within a VBA macro? For example, I need to perform a save as and overwrite an existing file. Of course, excel knows the file exists and asks if you want to perform the overwrite. Since multiple users will be performing the macro, I want to be able to force them to do the overwrite. Any ideas? Thanks! JenReyn |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Force Response in Dialog Box
JenReyn,
Setting DisplayAlerts set to False will skip the overwrite warning. Sub testit() Dim blnTemp As Boolean blnTemp = Application.DisplayAlerts Application.DisplayAlerts = False ThisWorkbook.SaveAs "C:\T\test.xls" Application.DisplayAlerts = blnTemp End Sub Rob "JenReyn" wrote in message ... Is there a way to force the response in a dialog box within a VBA macro? For example, I need to perform a save as and overwrite an existing file. Of course, excel knows the file exists and asks if you want to perform the overwrite. Since multiple users will be performing the macro, I want to be able to force them to do the overwrite. Any ideas? Thanks! JenReyn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I transform a word response to a numeric response? | Excel Discussion (Misc queries) | |||
How do I set up a daily call out response response register? | Excel Worksheet Functions | |||
Can you Force a Response for Questionnaire | Excel Discussion (Misc queries) | |||
Selecting a response on a dialogue box from a Macro | Excel Discussion (Misc queries) | |||
Macro for Customer response time | Excel Programming |