Macro Error Message with no Module attached

pbornemeier

Well-known Member
Joined
May 24, 2005
Messages
3,807
I was getting this error message when I opened some Excel files I inherited:

This workbook contains one or more Microsoft Excel 4.0 macros. These macros may contain viruses or other harmful code. Open this workbook only if you trust the source. Do you want to enable these macros?

There were no modules attached to the file.

Macros created in the older version of Excel (v4.0 released 1992) can be displayed in the Insert | Name | Define ... dialog box.

Range names and Excel 4.0 macro names are listed in this dialog box. Deleting those macros will eliminate the error message. To understand/edit those macros the following links may be of use:

mrexcel.com link to external site:
http://www.mrexcel.com/archive/Office/5098.html

Microsoft link to file describing Excel 4.0 macro functions (be careful - it may replace an existing help file):
http://office.microsoft.com/en-us/excel/HP010475331033.aspx
Note that there are some Excel 4.0 macros that have no direct VBA equivalent. See "ExecuteExcel4Macro Method" in VBA help.
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Watch MrExcel Video

Forum statistics

Threads
1,099,114
Messages
5,466,760
Members
406,497
Latest member
Bryanlim

This Week's Hot Topics

Top