Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom event
Is there any possibility to create a custom event in VBA (excel)?
I'm trying to block a prompt that is shown when I delete a sheet with data on it. There's no such option in "Options". I could do it via macro, but there seems to be no "Worksheet_Delete" event or something. May be there is some possibility to create a custom event? Thanks in advance for your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom event
try this. true will automatically come back after the macro.
Sub delsheet() Application.DisplayAlerts = False ActiveSheet.Delete End Sub -- Don Guillett SalesAid Software "andriil" wrote in message ... Is there any possibility to create a custom event in VBA (excel)? I'm trying to block a prompt that is shown when I delete a sheet with data on it. There's no such option in "Options". I could do it via macro, but there seems to be no "Worksheet_Delete" event or something. May be there is some possibility to create a custom event? Thanks in advance for your help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom event
yes, it deletes a sheet. but I want to delet it in a normal way, but without
alerts. if I rightclick the sheet and select "delete", an alert appears. Is there any "Deletesheet" event that could intercept it? Is there a way to create non-standard, custom alerts? Thank you very much for your help! "Don Guillett" wrote: try this. true will automatically come back after the macro. Sub delsheet() Application.DisplayAlerts = False ActiveSheet.Delete End Sub -- Don Guillett SalesAid Software "andriil" wrote in message ... Is there any possibility to create a custom event in VBA (excel)? I'm trying to block a prompt that is shown when I delete a sheet with data on it. There's no such option in "Options". I could do it via macro, but there seems to be no "Worksheet_Delete" event or something. May be there is some possibility to create a custom event? Thanks in advance for your help! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom event
Go back to your original posting and see some methods I posted.
Gord Dibben Excel MVP On Fri, 16 Dec 2005 11:36:03 -0800, "andriil" wrote: Is there any possibility to create a custom event in VBA (excel)? I'm trying to block a prompt that is shown when I delete a sheet with data on it. There's no such option in "Options". I could do it via macro, but there seems to be no "Worksheet_Delete" event or something. May be there is some possibility to create a custom event? Thanks in advance for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom color palette does not get transferred with the workbook. Excel 2003 | Excel Discussion (Misc queries) | |||
make custom formatting permanent | Excel Worksheet Functions | |||
Can you link a custom property to an Excel custom header text? | Setting up and Configuration of Excel | |||
Custom charts - default formatting | Charts and Charting in Excel | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) |