Thursday, December 22, 2011

How do I Delete Control From Excel Spreadsheet at Runtime?


1. Click the Office Button, then click 'Excel Options'.
2. Select the 'Popular' category and check the 'Show Developer Tab In The Ribbon' box. Click 'OK'.
3. Open the Developer tab and click 'Design Mode'.
4. Find the control you want to delete. It will be surrounded by a border, either simple and thin, or thick and dotted, depending on whether or not it is an ActiveX control. Click on this border to select the control.
5. Press the 'DELETE' key on your keyboard.

Blogger news