Macros

  • Thread starter Thread starter LucB
  • Start date Start date
L

LucB

I deleted all macros from my workbook and still get a 'Workbook contains
macros' warning when opening the file. Is this a bug? What can I do to avoid
the message?
 
Hi
you also have to delete the (empty) modules:
- open the VBA editor (ALT+F11)
- select your modules and delete them
- close your VBA editor and save the workbook
 
Hi LucB!

See:
Chip Peason:
http://www.cpearson.com/excel/vbe.htm

You'll see code for deleting all VBA code in a project. And, perhaps
as important, code for exporting all code.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top