It is difficult to comment without reviewing. Could you please right click
the button 'Assign Macro' and reassign the macro.

If this post helps click Yes
---------------
Jacob Skaria


" wrote:

I have recorded a GoalSeek macro in Excel 97 SR2, which works when
called from the Tools | Macro menu, but when I call it from a button
on the spreadsheet then the macro fails in the GoalSeek command.

My macro is . . .

Sub BalancePC()
'
' BalancePC Macro
' Macro recorded 24/03/2009 by Alan G Lloyd
'

'
Worksheets("Financial Statement").Range("M37").GoalSeek _
Goal:=0, _
ChangingCell:=Worksheets("Financial Statement").Range("I25")

End Sub

Alan Lloyd