Sunday, 4 October 2009

Adding Controls to Excel Spreadsheets (Forms Toolbox) and other Tricks

Forms Toolbar

First ensure the "Forms Toolbox" is visible (View->Toolbars->Forms). Then add a button to the worksheet (Click on the button icon and then "draw" the button in the sheet). It will prompt you for a macro name. Think of one and click ok. You can then record a macro.

How to Undo an "Undo"

Undoing an "Undo" is the same as doing a "Redo". This can be down via the Redo button (part of the Standard toolbar in Excel).

No comments: