Deleting Sheets - Without a prompt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Anyone know if its possible to switch off prompting for confirmation when a
macro wants to delete a sheet ?

I've tried using sendkeys with " " to click the default button but that
doesn't seem to work.

Thanks, Nick
 
Give this a whirl...

Application.DisplayAlerts = False
Sheets("Sheet1").Delete
Application.DisplayAlerts = true
 
Thanks Jim

How simple !

Jim Thomlinson said:
Give this a whirl...

Application.DisplayAlerts = False
Sheets("Sheet1").Delete
Application.DisplayAlerts = true
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automatically deleting a worksheet (without warning prompt) 3
Save without Macros without prompting 1
Delete sheet without prompt 3
Adding An If Clause after Prompt 1
Delete chart without being prompted? 2
Delete Sheet executing macro 3
deleting sheet 4
Deleting sheets 3

Back
Top