⟩ Can I have my Macro make Excel NOT ask "the file already exists, do you want to overwrite" type of questions?
Application.DisplayAlerts = False
'code to save, overwrite, delete, whatever goes here
Application.DisplayAlerts = True
Question and Answer:
Home MS Excel
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
I have a user defined function that does not recalculate?
Can I ask my user for confirmation before executing the macro?
I want to add a toolbar to my spreadsheet that when clicked, brings up Userform1?
When a button is drawn onto a sheet the assign macro is not displayed. When right-clicking on the button the "Assign Macro" context menu item is not present?
How do I run a macro every time a certain cell changes its value?
I want to show a userform each time my file is opened?
Is there a way to protect the macros I create so people can not see or alter them?
Is it possible to call a macro from the condition true or false side of a worksheet formula? i.e. If(A2="OK",Run macro1,run macro2)?
How can I save a chart as a GIF file?
How can I print a workbooks full path in the header or footer? The Page Setup dialog box does not seem to offer the option.?
