View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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