How to delete macros
 

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

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 FileRemove Module1 and say no to exporting it.

--

HTH

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


"Jaime Stuardo" wrote in message
...
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

Thanks Bob! it worked!

"Bob Phillips" wrote:

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 FileRemove Module1 and say no to exporting it.

--

HTH

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


"Jaime Stuardo" wrote in message
...
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