How can i insert data into sheet without going thruogh the undo buffer ?

[Tomer]

HI all!
i am trying to control the excel user interface by catching the Change
event,
and insert a bool value into an hidden column for each line in the
sheet.

my problem is that my hidden column is locked, and if user wants to
undo his last change,
he is actually tring to delete my inserted bool value (into my hidden
column), and this action is forrbiden.

furthermore, even if it is my column is unlocked, undo action will
actually delete my inserted value before it will undo the user change.

that's why i need an answer to my topic:
How can i insert data into sheet without going thruogh the undo buffer
?

Thanks a lot
Tomer

 

[Tom Ogilvy]

Actually, I would expect your code to clear the undo buffer so the users
action or your codes action can't be undone.

What you should do is control the undo yourself. See OnUndo in Excel VBA
help.

See John Walkenbach's discussion at
http://www.j-walk.com/ss/excel/tips/tip23.htm