- 1). Go to the "View" menu and select "Forms" from the "Toolbars" section. This will open a new toolbar with several form objects that can be inserted for use with VBA macros.
- 2). Select the "Button" option, then drag an area over the spreadsheet where you want the button to be placed. When you place the button, a window will pop up with a list of macros that are available.
- 3). Select the macro you wish to assign to this button, then press the "OK" button. From now on, whenever you press this button, the assigned VBA macro will be run in Excel.
previous post