Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Mar 2004
    Location
    Mackay, Queensland, Australia
    Posts
    26
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Is there a way to simply assign an existing macro to a command button in Excel 2003? As far as I can see you have to create the button, then get into Visual Basic and copy and paste the code from the macro into the vb for the command button. Surely there's an easier way. In earlier versions you could just right click the command button and choose Assign Macro and in 2007 it's all easy, but in 2003???
    Thanks in anticipation
    Suzanna

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    It is still easy as long as you use the commandbutton from the forms toolbar and not from the control toolbix toolbar!
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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