Excel 4.0 Macro

**Mary Frances** · 02-19-2008, 01:08 PM

I use an 8 mg workbook in Excel 2003. I have always gotten the "Security Warning Box" that says "C:\Documents and Settings....contains macros. Macros may contain viruses....", and then three choices to enable, disable or more info. Recently I began getting a second error message "This workbook contains 1 or more Microsoft Excel 4.0 macros. These macros may contain......", and have to again, enable. I would like to get rid of the second message. I have tried opening the workbook, deleting all of the macros, saving it under another name and closing it. But when I re-open it I still get the error message about Excel 4.0 macros. I don't know where to find these. Can anyone help?

**floydbird** · 02-19-2008, 01:41 PM

What O/S are you running? To which level have you set security?

**shg** · 02-19-2008, 02:02 PM

The macro could be on a hidden sheet, or could be used in a named formula.

To check for the former, open the VBE and see if there are any sheets that don't show up with tabs in the workbook (Hidden or VeryHidden).

For the latter, do Insert > Name > Define, and look at all the names.

**Mary Frances** · 02-19-2008, 05:01 PM

Originally Posted by shg

The macro could be on a hidden sheet, or could be used in a named formula.

To check for the former, open the VBE and see if there are any sheets that don't show up with tabs in the workbook (Hidden or VeryHidden).

For the latter, do Insert > Name > Define, and look at all the names.

I have un-hidden all of the sheets, and there are no macros show up that were not there before. What is a VeryHidden Sheet?

Also, there is only one "Name" that shows up, and that is for a conditional formatting I created recently (in Excel 2003).

Any other suggestions? I am at a loss.

**shg** · 02-19-2008, 05:47 PM

VeryHidden is an attribute that keeps sheets from being seen when you do Format > Sheet > Unhide. You can open the VBE (Alt+F11), open the Project Explorer window within it (Ctrl+R), and verfy that all the sheets listed appear in the workbook.

**Mary Frances** · 02-20-2008, 12:00 PM

Originally Posted by shg

VeryHidden is an attribute that keeps sheets from being seen when you do Format > Sheet > Unhide. You can open the VBE (Alt+F11), open the Project Explorer window within it (Ctrl+R), and verfy that all the sheets listed appear in the workbook.

Yes, all of the sheets are accounted for. There are no very hidden sheets in the workbook. Is there a place to locate macros in a workbook except for Tools-Macros.

Could I have copied some information from a previous version of the workbook that brought along an old macro?

Any suggestions would be appreciated.