| 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 . |
| 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) | |||
Threaded Mode
