Add Button to a sheet

  • Thread starter Thread starter PR
  • Start date Start date
P

PR

I would like to add a button to a sheet (not toolbar) to do a sort on a
selection of data. I have created the macro I wish to use, I would like to
attached the Marco to a button.

Can this be done , if so how.

PR
 
view>toolbars>forms>click on the button>cursor becomes arrow>size in area
desired>click x on forms menu.
Better to put on your toolbar
right click toolbar>customize>forms>grab button>drag to toolbar>use from
there

I usually use a shape for my macro buttons.
 
Tools>Customize. Select the Forms Toolbar.

Click on the "button" icon.

Draw a button on your sheet.

Right-click that button and "Assign Macro".

Edit the button text to something appropriate and you're done.

Just about any object can be placed on a sheet and have a macro assigned to
it.

Wordart, Clipart, Picture from file and a host of others.

Gord Dibben Excel MVP
 
Back
Top