I have an Excel worksheet with Buttons and Macros and Visual Basic code which
was created in Excel 2003 and works fine (everything functions). However,
when I moved the file to Excel 2007, only the Visual Basic Function no longer
works (the macros and buttons operate fine).

When I use "Evaluate Formula" for the Visual Basic Function, it provides the
correct answer. However, when I press Calculate (F9) or when I press Enter
with the cursor at the end of the function's formula on the "Fx" line, I get
"#VALUE!" and don't understand why. Any ideas? Thanks.