How to activate a macro when delete a sheet?

Posted by moujia on May 23, 2000 5:04 AM

I write a macro to create a new menu with each
sheet's name as menu items. Now, when I delete a
sheet, surely I want the menu to be updated. How
could I trigger this?

Thanks in advance.

Posted by Ivan Moala on May 23, 2000 5:37 AM

The menu won't uppdate automatically unless you call it to.
If you delete a sheet put in a call to the routine
that created your Menus.
You could do this automatically vai sheetsdeactivate event but this would have to be ?

Ivan