code execution has been interrupted
 

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveWorkbook.Save
End Sub

I put this code into a shared workbook, so the workbook will be saved
whenever a person makes any change.

But this code always generate an error "code execution has been
interrupted" and it stops at the "End Sub".

Why?

H.Z.

code execution has been interrupted
 

Your code runs for me. But shouldn't you use the Worksheet_Change event?
Do you need to save every time the user moves the cell selector?

--
Jim
"Who I Am" wrote in message
oups.com...
| Private Sub Worksheet_SelectionChange(ByVal Target As Range)
| ActiveWorkbook.Save
| End Sub
|
| I put this code into a shared workbook, so the workbook will be saved
| whenever a person makes any change.
|
| But this code always generate an error "code execution has been
| interrupted" and it stops at the "End Sub".
|
| Why?
|
| H.Z.
|