View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default IS THERE A WAY TO CLEAR WORKSHEET EVENTS USING ANOTHER MACRO

Reha

See Chip Pearson's site for info and code.......

Specifically the section on "Deleting all VBA code in a project"

About 2/3 of the way down the page.

http://www.cpearson.com/excel/vbe.htm


Gord Dibben MS Excel MVP

On Sat, 9 Dec 2006 02:45:25 +0200, "Reha" wrote:

Hi,

I have a workbook of several sheets and all sheets have worksheet events. My
problem is I do not want them sticked to my attached file when I run my
email macro. Is there a possibility to insert a code to my outlook macro
will be able to clear the worksheet events of my attached file automatically
or any workbook event delete them on exit.

Thanks for kindest supports

Reha