software

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 quot;Optionsquot;. I could do it via macro, but
there seems to be no quot;Worksheet_Deletequot; event or something. May be there is
some possibility to create a custom event?
Thanks in advance for your help!

try this. true will automatically come back after the macro.

Sub delsheet()
Application.DisplayAlerts = False
ActiveSheet.Delete
End Sub

--
Don Guillett
SalesAid Software

quot;andriilquot; gt; wrote in message
...
gt; Is there any possibility to create a custom event in VBA (excel)?
gt; I'm trying to block a prompt that is shown when I delete a sheet with data
gt; on it. There's no such option in quot;Optionsquot;. I could do it via macro, but
gt; there seems to be no quot;Worksheet_Deletequot; event or something. May be there
gt; is
gt; some possibility to create a custom event?
gt; Thanks in advance for your help!
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 quot;deletequot;, an alert appears.
Is there any quot;Deletesheetquot; event that could intercept it?
Is there a way to create non-standard, custom alerts?
Thank you very much for your help!

quot;Don Guillettquot; wrote:

gt; try this. true will automatically come back after the macro.
gt;
gt; Sub delsheet()
gt; Application.DisplayAlerts = False
gt; ActiveSheet.Delete
gt; End Sub
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;andriilquot; gt; wrote in message
gt; ...
gt; gt; Is there any possibility to create a custom event in VBA (excel)?
gt; gt; I'm trying to block a prompt that is shown when I delete a sheet with data
gt; gt; on it. There's no such option in quot;Optionsquot;. I could do it via macro, but
gt; gt; there seems to be no quot;Worksheet_Deletequot; event or something. May be there
gt; gt; is
gt; gt; some possibility to create a custom event?
gt; gt; Thanks in advance for your help!
gt;
gt;
gt;

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, quot;andriilquot;
gt; wrote:

gt;Is there any possibility to create a custom event in VBA (excel)?
gt;I'm trying to block a prompt that is shown when I delete a sheet with data
gt;on it. There's no such option in quot;Optionsquot;. I could do it via macro, but
gt;there seems to be no quot;Worksheet_Deletequot; event or something. May be there is
gt;some possibility to create a custom event?
gt;Thanks in advance for your help!