Macros?

  • Thread starter Thread starter Rosiewednesday
  • Start date Start date
R

Rosiewednesday

If I am creating a macro from scratch in VB, and not recording it, can I get
a button at the top where users can click it to run the macro? I want to
make it as simple as possible.

Thanks,
Rosie
 
To: Rosiewednesday,

Goto: Tools > Customize
Click on the Commands tab.
Move down the Categories list to Macros and select it.
Select your macro from the Commands list.
Drag and drop your selected macro to the toolbar.
Right click on your new button.
Rename (if you wish) your button name, after "Name:"
And click on "Edit Button Image" (if you want to add a button icon).

Steven Craig Miller
 

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

Back
Top