Does this problem occur only when calc mode is automatic? If so and if you
have any UDFs it might be an interaction with them.

--
Jim
wrote in message
...
| 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.