Macro, Auto Return

B

Baloney12

I'm writing a macro in excel and have to create temporary tabs within the
file, and then delete them. Is there any way I can write into the macro a key
return so when it asks if I'm sure I want to delete it does it automatically,
because everytime I run the macro it stops at the point the temporary sheet
is being deleted and wants me to confirm it, and I have to hit enter to
continue
 
F

FSt1

hi
just before the delete, add this line
Application.DisplayAlerts = False

then after the delete has happened, add this line
Application.DisplayAlerts = true

regards
FSt1
 

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

Macro to select and delete levels of a document 2
Drop down list control value in vba 2
Improving Macro That Keeps First Letter 0
Global Template Network and saving auto texts & macros 2
write vba to a worksheet via a macro 3
Macro Creating Auto Separation of Numbers thru Defining Delimiter 1
Macro to Convert Value to Number, Sort, then Delete 17
Dump ListBox Contents to Sheet & Stay on Active Sheet 0

Top