Excel 4.0 Macro

[Mary Frances]

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]

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

[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.

[Mary Frances]

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

I have it on the Medium setting

[Mary Frances]

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]

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]

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.

[shg]

Mary Frances, I have no other suggestions. VBA Noob has a very good grasp of XLM macros; perhaps he'll stop buy.

[VBA Noob]

Shg,

I've only really come across Excel 4.0 macros from Walkenbach and chip site's. I've use it in the past to highlight formulas

http://www.j-walk.com/ss/excel/usertips/tip045.htm

http://www.cpearson.com/excel/Call.htm

Maybe you could see if you have a named range refering to the GET.CELL Excel 4.0 macro or upload the file

Another option is to copy the sheets to a new workbook
http://www.j-walk.com/ss/excel/tips/tip58.htm

Here are a few other sites

http://support.microsoft.com/default...S;Q128185&FR=1

http://www.mrexcel.com/archive2/18800/21312.htm

VBA Noob

[shg]

Thanks, Noob.

[Mary Frances]

Shg,

I've only really come across Excel 4.0 macros from Walkenbach and chip site's. I've use it in the past to highlight formulas

http://www.j-walk.com/ss/excel/usertips/tip045.htm

http://www.cpearson.com/excel/Call.htm

Maybe you could see if you have a named range refering to the GET.CELL Excel 4.0 macro or upload the file

Another option is to copy the sheets to a new workbook
http://www.j-walk.com/ss/excel/tips/tip58.htm

Here are a few other sites

http://support.microsoft.com/default...S;Q128185&FR=1

http://www.mrexcel.com/archive2/18800/21312.htm

VBA Noob

You may have hit on the problem. Previously I asked for a conditional format that would change the shading of a cell when there is a formula in that cell. you suggested I go to http://j-walk.com/ss/Excel/usertips/tip045.htm, and I followed the instructions. (Insert-Name-Define,CellHasFormula, =GET.CELL(48,INDIRECT("rc",FALSE)), Conditional Formatting-=CellHasFormula,OK) Is that what has caused the Excel4.0 message box when I open the workbook?

[VBA Noob]

Is that what has caused the Excel4.0 message box when I open the workbook?

Yes.


VBA Noob

[shg]

The macro could be on a hidden sheet, or could be used in a named formula. ... do Insert > Name > Define, and look at all the names.

Didn't that show up when you looked at the names?

[Mary Frances]

Yes.


VBA Noob

So, that formula is an Excel 4.0 formula? Why does it not convert to Excel 2003 when I create it in an Excel 2003 workbook.

Is there a way to eliminate the second message box regarding Excel 4.0 macro still keeping the conditional formatting?

[VBA Noob]

I don't believe so.

You could try a normal macro instead

http://exceltips.vitalnews.com/Pages..._Formulas.html

VBA Noob

[Mary Frances]

I don't believe so.

You could try a normal macro instead

http://exceltips.vitalnews.com/Pages..._Formulas.html

VBA Noob

You are an Excel Genius!!!!! Thanks. This is exactly what I needed.