Shortcut key

[Mary Ann]

Is there a shortcut key to delete a worksheet?
I use Excel 2003 and 2007

 

[FSt1]

hi
short answer no.
but you can record a macro that does that and attach the macro to a custom
icon.
sub delsheet()
activewindow.selectedsheets.delete
end sub

regards
FSt1

 

[FSt1]

hi
sorry, you wanted a short cut key. yes you can do that too.
2003 on the menu bar>tools>macros>macros.
select your macro then click options. assign your custom shortcut key.
not sure how to do that in 2007 yet. working on it.

Regards
FSt1

 

[Gord Dibben]

If you don't want the warning message add

Application.DisplayAlerts = False

activewindow.selectedsheets.delete

Application.DisplayAlerts = True


Gord Dibben MS Excel MVP