CODEWITHSUNDEEP
vbaexcel
CustomX
CustomX

Reputation: 10113

Excel macro - open macro without going into Visual Basic?

I've finished my macro! But is there an easier way in runnning it?

I know two ways

Is there an easier way, or are these the only two ways?

Thanks

Upvotes: 3

Views: 496

Answers (3)

Jon Peltier
Jon Peltier

Reputation: 6053

There are several options:

Toolbar or Menu (Excel 2003 & earlier)

http://peltiertech.com/WordPress/how-to-assign-a-macro-to-a-toolbar-or-menu/

ActiveX control

http://peltiertech.com/WordPress/how-to-assign-a-macro-to-an-activex-control/

Button (Forms menu control) or Shape

http://peltiertech.com/WordPress/how-to-assign-a-macro-to-a-button-or-shape/

Upvotes: 3

Bek Raupov
Bek Raupov

Reputation: 3777

you can even create little smiley icon in your Toolbar so that it stays there and you can run it by clicking it or have shortcut keys attached to it.

Upvotes: 3

Jean-François Corbett
Jean-François Corbett

Reputation: 38500

Place a command button on your sheet, view its code in the VB editor, and edit it so it looks something like this:

Private Sub CommandButton1_Click()
    Call MyMacro
End Sub

You can then just click your button every time you want to run your macro.

Upvotes: 5

Related Questions