How to delete macros

[Guest]

ToHi all...

I have a workbook that I have with a macro to populate the sheets. Now I
want to deliver this workbook to my customer. I need to delete the macros so
that Excel will not ask user to enable or disable macros.

I went to Tools -> Macro -> Macros and delete all macros there, and I save
the workbook.

Now, when I open the book again, excel asks me again abut disabling or
enabling macros.

How can I effetively delete them?

Thanks
Jaime

 

[Bob Phillips]

Jamie,

You also need to remove the code module.

Go into the VB IDE (Alt-F11), and in that workbook project, select the code
module, and go to File>Remove Module1 and say no to exporting it.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks Bob! it worked!

Jamie,

You also need to remove the code module.

Go into the VB IDE (Alt-F11), and in that workbook project, select the code
module, and go to File>Remove Module1 and say no to exporting it.

--

HTH

RP
(remove nothere from the email address if mailing direct)