Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skip Override Prompt in Macro
I have a histogram macro that I am trying to run, but I receive a prompt that says something like "output range will overwrite existing data. Press OK to overwrite data in range..." The window displays the "OK" button, "Cancel", and "Help". How do I have the macro shut this off or power through this automatically? PS: The macro runs 20 histograms sequentially. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skip Override Prompt in Macro
Maybe application.displayalerts = false code to run application.displayalerts = true Gord Dibben MS Excel MVP On Thu, 25 Jun 2009 13:20:02 -0700, iperlovsky wrote: I have a histogram macro that I am trying to run, but I receive a prompt that says something like "output range will overwrite existing data. Press OK to overwrite data in range..." The window displays the "OK" button, "Cancel", and "Help". How do I have the macro shut this off or power through this automatically? PS: The macro runs 20 histograms sequentially. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skip Override Prompt in Macro
For a more general solution, there is always "Tools/Options.../Edit", "Alert before overwriting cells" (uncheck the box). Eric "iperlovsky" wrote: I have a histogram macro that I am trying to run, but I receive a prompt that says something like "output range will overwrite existing data. Press OK to overwrite data in range..." The window displays the "OK" button, "Cancel", and "Help". How do I have the macro shut this off or power through this automatically? PS: The macro runs 20 histograms sequentially. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skip Override Prompt in Macro
I tried this but it did not work. Maybe it has to do with the alert type: overwrite existing cells. Any ideas? Here is some of the code: Sub Histo() Application.DisplayAlerts = False Application.Run "ATPVBAEN.XLA!Histogram", ActiveSheet.Range("_01"), ActiveSheet.Range("$FV$34"), _ , False, False, False, False Application.Run "ATPVBAEN.XLA!Histogram", ActiveSheet.Range("_02"), ActiveSheet.Range("$FX$34"), _ , False, False, False, False Application.DisplayAlerts = True End Sub "Gord Dibben" wrote: Maybe application.displayalerts = false code to run application.displayalerts = true Gord Dibben MS Excel MVP On Thu, 25 Jun 2009 13:20:02 -0700, iperlovsky wrote: I have a histogram macro that I am trying to run, but I receive a prompt that says something like "output range will overwrite existing data. Press OK to overwrite data in range..." The window displays the "OK" button, "Cancel", and "Help". How do I have the macro shut this off or power through this automatically? PS: The macro runs 20 histograms sequentially. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Override a built-in command with a macro | Excel Programming | |||
Override prompt for Office Clipboard | Excel Discussion (Misc queries) | |||
How to skip save prompt ask me if I want to replace File. | Excel Programming | |||
How to skip save prompt ask me if I want to replace File. | Excel Programming | |||
Macro override password protection | Excel Programming |