Shortcut key

  • Thread starter Thread starter Mary Ann
  • Start date Start date
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
 
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
 
If you don't want the warning message add

Application.DisplayAlerts = False

activewindow.selectedsheets.delete

Application.DisplayAlerts = True


Gord Dibben MS Excel MVP
 
Back
Top