ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro Help (https://www.excelbanter.com/excel-discussion-misc-queries/263056-macro-help.html)

Bruce D.

Macro Help
 
I am using a macro and at the end of the process I am deleting a worksheet.
When this performs a pop up appears waiting to accept clicking on the delete
button to continue. Is there a default setting somewhere to prevent excel
asking for this to be done or can I code this to accept the delete button
somehow in my macro.

Thanks.
--
Bruce

Don Guillett[_2_]

Macro Help
 
You should ALWAYS post your code for comments
application.displayalerts=false


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bruce D." wrote in message
...
I am using a macro and at the end of the process I am deleting a worksheet.
When this performs a pop up appears waiting to accept clicking on the
delete
button to continue. Is there a default setting somewhere to prevent excel
asking for this to be done or can I code this to accept the delete button
somehow in my macro.

Thanks.
--
Bruce




All times are GMT +1. The time now is 10:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com