Setting Font properties in Code clears Undo list

  • Thread starter Thread starter Lorin
  • Start date Start date
L

Lorin

Excel 2002
Whenever I change the Font properties of a cell programmtically (i.e.
activecell.font.size = 10), the undo list clears automatically. This also
occurs if I changethe Style property of the cell programatically. Does
anybody know why this happens? Is there a way to stop if from happening? I
appreciate any help you can give me.

Lorin
 
Create your own stack could be misinterpreted (that it is possible to do
this for the undo feature). Trevor means you would have to write a complete
undo feature yourself unless he knows something I don't.

Regards,
Tom Ogilvy
 
Tom

"... unless he knows something I don't." I think it's highly unlikely that
I know something that you don't. You are, of course, absolutely correct in
your interpretation. Sometimes less is more ... sometimes not. ;-)

Regards

Trevor
 
Back
Top