Excel 4.0 Macro

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.

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.

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

Thanks, Noob.

Originally Posted by 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

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?

Originally Posted by 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?

Originally Posted by VBA Noob

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?