How to add a button such that button just run your macro

[priya2208]

need help...

i have wriiten macro which takes header fields from two excel sheet

but i need to add button in my excel sheet such taht when we press that button it will run that macro.

 

[Luke M]

Assuming the macro is not classified as private...


From the Forms toolbar, (or in 2007+, Developer Ribbon, Insert) insert a Command button or any basic shape. Right click on object, assign macro.

 

[dan_l]

?


1. Insert a button.

2. Assign your macro to the button.

 

[aliasger.q]

Hello, very nice,

But is this possible in 2003 also as i am looking in 2003 but din't find it


??

Thanks

 

[Luke M]

In 2003, View - Toolbars - Forms, or

View - Toolbars - Drawing

 

[aliasger.q]

Thanks, i got it.