don't confirm deletion of a sheet with macro

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

Guest

Hi,

After running a macro I receive a window asking me to confirm a deletion of
a worksheet. The same macro just did the deletion of the worksheet without
asking me to dele it with Excell XP but after I upgraded to Excell2003 every
time I run the macro it asks me to confirm the deletion of that sheet. I
guess I need to change any options but can’t find it in the Excell2003
options menu.
 
Hi
try
application.displayalerts=false
'delete sheet
application.displayalerts=true
 
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

getting rid of the "confirm delete" dialogue box when deleting a s 5
another macro query - deleting a worksheet within a query 2
How to avoid delete confirmation 1
Confirm a choice before Macro 3
Confirm Delete in a macro 2
Excel 2007: Help creating a macro that will run Solver? 3
can someone help me with macros? 4
Macro Help 1

Back
Top