Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 crashes after viewing property sheet in Data Connection | New Users to Excel | |||
Delete values in sheet 2 that arre found in sheet 1 | Excel Discussion (Misc queries) | |||
2007: Property Sheet button disabled | Excel Discussion (Misc queries) | |||
Best way to inser file property into and excel sheet (cell) | Excel Discussion (Misc queries) | |||
Print>Properties>Layout>Pages per sheet: this function/property . | Excel Discussion (Misc queries) |