Marcro

P

pommel

Hi Guys/girls

Im new in using macro's, and have made my first simpel macro functions

Is it possible to create an button in the excel sheet, where, when i press
the button one of the macros will run.

Till now i used the softkey

Thanks in advance!!!
 
M

Mike H

Try this

View|Toolbars - Forms

Click the 'Button' icon on the toolbar and on your worksheet hold down the
left mouse button and drag to get the size of button you need. In the popup
menu that appears click 'New' and paste your macro in there. Or, navigate to
an existing macro and select it and click OK.


Mike
 
S

Shasur

Hi

You can add a button from the Forms toolbar and position it on a spreadsheet

Then you can Assign a macro by selecting the button -->Right Click -->Assign
Macro

Cheers
Shasur
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top