View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 2
Default Is there a Sheet delete property?

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 7/28/2003
ActiveSheet.Select
ActiveWindow.SelectedSheets.Delete
End Sub
-----Original Message-----
Hi,

When you have deleted a sheet and catch it in the

deactivate event, is
there a property in the object model that indicates that

you have
selected delete sheet? The reason why I need to know is

because the
deactivate event is fired even when you switch between

sheets and I
only want to perform certain actions when delete has

been selected?

Thanks,

Rick
.