Hello,

I am able to programatically add borders to cells or range or multiple
ranges. But I am unable to programatically undo the borders applied.
Can someone let me know if this is a bug.

// the below line works
oActiveSheet.get_Range("A1:C5",oMissing).BorderAro und(oMissing,Excel.XlBorderWeight.xlThick,Excel.Xl ColorIndex.xlColorIndexAutomatic,oMissing);

// this doesnt work
oExcelApp.Undo();

Thanks
Prasanta

Hi Prasanta,

The undo feature in Excel only applies to actions taken by the user
through the UI. The undo stack doesn't contain anything you do
programmatically. If you want to be able to undo actions that your program
takes you'll have to roll your own undo stack, which is more trouble than
it's worth in the vast majority of cases IMO.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

"prasanta" wrote in message
oups.com...
Hello,

I am able to programatically add borders to cells or range or multiple
ranges. But I am unable to programatically undo the borders applied.
Can someone let me know if this is a bug.

// the below line works
oActiveSheet.get_Range("A1:C5",oMissing).BorderAro und(oMissing,Excel.XlBorderWeight.xlThick,Excel.Xl ColorIndex.xlColorIndexAutomatic,oMissing);

// this doesnt work
oExcelApp.Undo();

Thanks
Prasanta