07 November 2008

Deleting controls (possible active) on excel sheet

Today I had to send list of items in excel sheet.
As usual I would come up with the list by coping data from web page and pasting it into excel sheet. But what if you copy some control altogether with the data?
After I manually deleted couple of hundred right on excel sheet :-(, I figured I might be able to automates the process of deleting those hated cheque boxes.
As usual I was right, soon after I sent my excel (without cheque boxes of course)


Link: Deleting controls programmatic.

No comments: