Unwanted Macro Warning for workbook containing no macros

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
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top