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 . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a Sheet delete property?
Does anyone have any ideas on my original question? See my first post
in this message?? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a Sheet delete property?
Hi Rick:
There is no trappable Worksheet_Delete event. A workaround might be to use the Deactivate event and then check if the worksheet still exists. Regards, Vasant. "Rick De Marco" wrote in message om... Does anyone have any ideas on my original question? See my first post in this message?? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a Sheet delete property?
Thanks Vasant,
Do you know if there is a way to cancel a sheet being deleted once a user has selected delete on the excel delete message box? Basically i am trying to stop users from deleteing a sheet if it has certain data in it. I don't want to protect the worksheet/workbook.. I will be doing my checking in the deactivate event and if certain criteria are meet then i need to cancel the delete.. Any ideas? Rick *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a Sheet delete property?
Sorry, Rick; AFAIK there is no way to prevent deletion of a sheet (without
protecting the workbook). Regards, Vasant. "Rick De Marco" wrote in message ... Thanks Vasant, Do you know if there is a way to cancel a sheet being deleted once a user has selected delete on the excel delete message box? Basically i am trying to stop users from deleteing a sheet if it has certain data in it. I don't want to protect the worksheet/workbook.. I will be doing my checking in the deactivate event and if certain criteria are meet then i need to cancel the delete.. Any ideas? Rick *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a Sheet delete property?
|
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) |