buttons & macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I,
a) add a button to a worksheet, and
b) assign a macro to that button?

tia
 
Easiest us selet forms toolar. Select button. This opens up macro
window-record macro. You didn't specify what event you want the button to
accomplish.
Pat
 
Thanks Pat, job done.
--
Jock Waddington


patrick said:
Easiest us selet forms toolar. Select button. This opens up macro
window-record macro. You didn't specify what event you want the button to
accomplish.
Pat
Click to expand...
 
Yes, here it is:
Easiest is select forms toolar. Select button. This opens up macro
window-record macro. You didn't specify what event you want the button to
accomplish.

I found it easier to record the macro first then add button and assign the
recorded macro.
 
You must log in or register to reply here.

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

Similar Threads

Collapsing all groups 0
Macro code behind button 1
Solver Compiler issue 2
Create A Button and Assign A Macro To It 2
Macor Button Dissapears 2
Command Button Question 8
How to call Excel add-in macro from a button… 1
Macro Buttons 4

Back
Top