How can I delete a tab in an excel spreadsheet using a Macro?

A

Art MacNeil

Hello,

I have a macro where I collect data, create a new tab, sort the data, then
move that data to yet another tab. I'd like to delete the 1st tab I created
but I get a pop-up window asking if I really want to delete the tab. Is
there any way to force the macro to delete the tab?

Thanks,

Art.
 
K

Ken Snell [MVP]

Are you doing this in ACCESS? or in EXCEL? This is an ACCESS newsgroup.

However, in EXCEL, see DisplayAlerts property for the Excel.Application
object.
 
A

Art MacNeil

Oops. It's excel. Thanks for the info.


Ken Snell said:
Are you doing this in ACCESS? or in EXCEL? This is an ACCESS newsgroup.

However, in EXCEL, see DisplayAlerts property for the Excel.Application
object.
Click to expand...
 

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

How to paste the same cell one tab over 1
How to delete previous data from 1 macro before running the next m 1
Global Template Network and saving auto texts & macros 2
Find Specific Rows in Range and Create New Tab 18
Transfer Spreadsheet not starting new Tab 1
Word macro that can call cells out of Excel for a find and replace 0
A couple questions BEFORE using Office 365 0
Pop up window?? 5

Top