Insert Function next to formula bar gives Run-time Error '50290'
 

Greetings,

Background:
We are using Office 2007 Pro Plus on XP SP2. We have a basic XLSM file with
the following Macro code:
Sub auto_open()
Application.OnEntry = "ChangeStatus"
End Sub

Sub ChangeStatus()
Application.StatusBar = "Changing formula" & Now
End Sub

When opening the file, we clicked Options -- Enable macros.

Problem:
When doing an insert function from the ribbon (Formulas tab -- Insert
function button on the far left), select SUM, click OK, enter 1 for number 1,
enter 2 for number 2, enter 3 for number 3, then click OK. The formula will
insert into the cell and the sum of the numbers, 6, will appear in that cell.

Now if you do the same above steps as you did, but this time using the
insert function button next to the formula bar, with the same macros enabled,
entering the same numbers, you will receive a MS VB Run-time Error '50290'.
Clicking Debug brings us to the line, Application.StatusBar = "Changing
formula" & Now, which does not have any issue since it worked with the insert
function button on the ribbon.

Can anyone help with this issue?

--
Nick