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...
 
Top