Hi All,

I am having a difficult time trying to resolve this issue.

I have a simple workbook, with a simple active x button. The onclick
subroutine for the button is very simple.

Private Sub CommandButton1_Click()
Sheets("Sheet1").Cells(1, 1).Value = 12345
Sheets("Sheet1").Cells(1, 2).Value = "test"
Sheets("Sheet1").Cells(11, 10).Value = "more testing"
End Sub

My problem is that when I click the button, only the first statement
is executed, Sheets("Sheet1").Cells(1, 1).Value = 12345, then nothing.
If I step through with debug, it highlights the first statement then
when I step through (F8) it does set the value but then it immediately
exits the subroutine.

I can use other statements and functions with no problem, but the
moment I try to alter the value of a cell it causes the sub or
function to exit.

Is there some configuration issue I am missing? I can't find any from
google or the news groups about anyone having problem like this.

Any help anyone can provide is greatly appreciated.