ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Why does my file say it has macros, but I can't find them? (https://www.excelbanter.com/excel-programming/380915-re-why-does-my-file-say-has-macros-but-i-cant-find-them.html)

Keith

Why does my file say it has macros, but I can't find them?
 
In addition to other responses, this can also happen if you have an empty
code module in your workbook. Press Alt-F11 to open up the Visual Basic
editor, then ctrl-R to make sure your project window is showing on the left,
then find your file and expand the folders if they aren't already expanded
(particularly, the Modules folder). then right click on each Module (default
names are Module1, Module2, etc.) and say "remove", and if it asks you if
you want to export, just say no.
Good luck,
Keith


"Elisa360" wrote in message
...
When I opened a file, a message popped up that said it contained macros
(and
then gave me the choice to enable or disable them). I want to delete
them,
but I can't find them in Tools-Macro-Macros?





All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com