View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Delette active sheet from form button

Hi,

That wouldn't cause an automation error, the sheet & button are deleted.
What else do you have in the module, post the code.

Mike

"TimSpangler" wrote:

When I try to delete the active sheet with a button that I have on the
sheet I get an automation error. I assume it is because the button is
firing the event and I am trying to delete the sheet that the button
is on.

Is there a way to do this? Any help would be appreciated

Thanks

TIM