Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MAcro Button (2000)

    I know this should be simple and have actually found methods on the Net that tell you how to do this using a form button. I can get the button to the toolbar and assign a macro, but cannot get the button on to the actual sheet. Is it possible to create a form button on the toolbar and then place it on the actual spreadsheet? If not, and I need to use the Control toolbox to create a button, how do I assign some code I have to the button? Thanks.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MAcro Button (2000)

    On the View menu select Toolbars. Then, on the popup menu select Forms. This should make the forms toolbar visable. Select the command button on the toolbar and then drag the mouse pointer on the worksheet to create a button the size you want.
    Legare Coleman

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MAcro Button (2000)

    With the button from the forms toolbox, you have to create a procedure in a module in the VBA Editor. Then assign that macro to the button. The controls from the forms toolbar are not as flexible with assigning code as the controls from the controls toolbar. When you have created a procedure in the VBA Editor, the procedure should show up in the assign macro dialog box when you create a button from the forms toolbar. You should just have to click on it to assign it to the button.
    Legare Coleman

  4. #4
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MAcro Button (2000)

    Thanks. However, if you create a button on the menu bar there is a quick way to assign the macro to the button. With the method you described it is asking to Assign a Macro|Record. I have the code already created. How do I assign the code which is already created? Maybe I am just being thick headed today <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15> .

    As mentioned being very thick headed today. Solved my own problem by playing around some more. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •