pbornemeier
Well-known Member
- Joined
- May 24, 2005
- Messages
- 3,915
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.
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.
