Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Font properties in Code clears Undo list
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Font properties in Code clears Undo list
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 "Trevor Shuttleworth" wrote in message ... Lorin Most, if not all VBA code clears the Undo stack. There is nothing that can be done about this unless you want to create your own stack. Regards Trevor "Lorin" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Font properties in Code clears Undo list
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 "Tom Ogilvy" wrote in message ... 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 "Trevor Shuttleworth" wrote in message ... Lorin Most, if not all VBA code clears the Undo stack. There is nothing that can be done about this unless you want to create your own stack. Regards Trevor "Lorin" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting the default properties for cells in all new spreadsheets | Excel Discussion (Misc queries) | |||
R1C1 - how can I permanently undo this setting in Excel? | Setting up and Configuration of Excel | |||
Setting format properties when opening Worksheet | Excel Worksheet Functions | |||
Setting properties for Embeded Excel in HTML | Excel Discussion (Misc queries) | |||
Setting Tab Properties in Excel | Excel Discussion (Misc queries) |