Persistant Alert re: macros

[Guest]

I've inherited a workbook that has been used for years. At one time, it had some marcos in it. Those macros no longer exist - they don't appear in the list of Macros, and there is no code within the VB editor. However, I still get a pop-up box every time I open the workbook, I get the message "The workbook xyz contains macros. ...

I know there is a security setting I can change to stop that message from appearing....however, from my perspective, it shouldn't appear at all. Is there anyplace else I can look to see what could be triggering it?

 

[Frank Kabel]

Hi
you also have to delete the 8now empty) modules:
- open the VBA editor (ALT + F11)
- remove/delete ALL modules from your workbook
- also check the worksheet modules and the workbook module for code
- close the VBA editor
- save the workbook and try again

 

[Tom Ogilvy]

in the project explorer that you show, go to each entry, right click on it,
select view code. click in the module, do Ctrl+a, then delete, click the
little X at the top of the module to close it. Repeat for all entries

Save the workbook, then close it and see if that fixes the problem.

 

[Frank Kabel]

Hi
double click on each entry to open the corresponding editor or use the
right mouse button and select code.