Opening 2010 .xlsm file in 2007 version of Excel

[Rlb53]

Is there a DLL file or add in that I can download to allow Excel 2007 operate a Macro / Userform Driven workbook that was generated in Excel 2010?

I get the "Can't Find Project or Library" Message.

When it defaults to the VBA Manager the "FORMAT" command is highlighted in the code listed below.

[vba]TextBox1.Value = Format(Sheets("sheet2").Range("b3"), "$0.00")[/vba]

Thanks.

[Paul_Hossler]

In the VBE in 2007, go to Tools, References and see if any are #MISSING.

If there are, uncheck it and save it

You might have to check the corresponding 2007 Reference

Sometimes that happens to me

Paul