Looking for something like BeforeChange event for Excel sheet

[sfatz]

I have an Excel spreadsheet in which I want to review user changes via code. If the change is not acceptable, I would like to restore the original value in the changed cell.

I tried using the SheetChange event, but when I try to restore the old value, the event fires again, trying to restore the previous value (user entered value), which fires the event again, and so on, and so on ...

Can anyone suggest a technique/method to restore a previous value to a cell that a user has modified? I would like to keep in mind that the value may be a user entered formula.

Thanks in advance for all posts to my question.

 

[PHV]

simply play with the Application.EnableEvents property in your event procedure.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[sfatz]

duh? Boy, sometimes it just sits there staring you right in the face. Thx a bunch.