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

  • Thread starter Thread starter Art MacNeil
  • Start date Start date
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.
 
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.
 
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...
 
Back
Top