ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   help: automated delete without question (https://www.excelbanter.com/excel-programming/274250-re-help-automated-delete-without-question.html)

John Wilson

help: automated delete without question
 
FireatHome,

Just prior to that line of code:
Application.DisplayAlerts = False
and just after it
Application.DisplayAlerts = True

John

FireatHome wrote:

In VBA I delete a sheet with this command:
"ActiveWindow.SelectedSheets.Delete"

I get a msgbox where I have to "OK" to perform the delete.

Q: How to delete without the msgbox




All times are GMT +1. The time now is 02:40 PM.

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