Sunday, May 9, 2021
Home Tags Disable warning

Tag: disable warning

Disable Alerts and Warning Messages in Excel

When building macros there can be times when the standard Excel warning alerts need to be disabled in order for the macro to complete it's intended function. An example may be where you have developed a macro that needs to create a temporary worksheet to store some values and then before completing the macro you need to clean-up and delete that sheet. The standard Excel warning alert would be presented unless you include some code to disable that alert.