How can I have VB automatically select "OK" or "Delete" on a Pop-up Window from Excel 2007

[Chopper50]

I have VB Code that is deleting a worksheet from a workbook. I use code < Sheets("Sheet1").Delete > and it deletes fine, however Excel has a Pop up that asks me if I for sure want to delete the sheet. How can I say "Delete" automatically with VB Code so I do not need user interaction.

Same issue when I save the worksheet. A pop up asks the user if they want to Continue because of the compatibility checker.

 

[Jonmo1]

Try adding this to beginning of code

Application.DisplayAlerts = False


Then set back to true at the end
Application.DisplayAlerts = True

 

[Chopper50]

Works GREAT. Thanks for your help.

 

[Jonmo1]

Glad to help, thanks for the feedback.