Unwanted Macro Warning for workbook containing no macros

  • Thread starter Thread starter Sameer
  • Start date Start date
S

Sameer

Dear All,
I am having a workbook.
I know that i had some macros in it and i deleted them. Now the
workbook is not having a single macro.
My personal.xls also does not contains any macros.
Tools-> Macro-->Macros does not show anything in any of the workbooks.
Still when i open my workbook it gives me warning like:
filename..... contains macros.
Why this may be? Any idea? How to avoid this?
Do revert. Thanks in advance.
-Sameer
 
You have to delete the modules that contained the macros as well. Alt-
F11 to bring up the VBE, and you will see a list of projects in the
upper left-hand panel. Right-click on any modules and then click on
Remove Module x - Excel will ask if you want to export the module
before deleting it, so click No. Repeat this for any other modules you
have, then save the file.

Hope this helps.

Pete
 
Back
Top