Thanks.

By the way, how would i Sub-class Excel? Is this possible to do with VB?



Tom Ogilvy wrote:

I would suspect your special features would be limited to what you can write
in VBA and what is available to you in the object model.

locking the cells, protecting the sheet and setting enableselection to
xlUnlockedCells would do a reasonable approximation to one aspect that you
described (as an example).

But you basic statement of instantiating application events and using the
change event is seems reasonable. Of course if you want to subclass excel
and hook into the windows message que and so forth, that would give you
greater control.