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