run macro when worksheet is deleted

[NMeeker]

I have a macro i would like to run whenever a user deletes a worksheet...

I would like the user to be able click as normal to delete,(ie. right clicking the tab and selecting delete worksheet, or selecting delete worksheet from the menu) but would like to run my macro when they select delete.

Any suggestions?

I am using excel 07 if that helps, or i could use another version...
My macro will save a copy of the deleted worksheet as xlveryhidden as a backup..

 

[GTO]

Thanks for testing the code Mark.

Glad it worked in XL2000.

ACK! Sorry - I should have mentioned that I checked the thread from work, so testing was in 2003. I'll repost after a chance to check at home/in 2000.

Mark

 

[GTO]

deleted...