+ Reply to Thread
Results 1 to 3 of 3

Can't Assign Macro to Command Button??

  1. #1
    Registered User
    Join Date
    10-02-2007
    Location
    Charlotte, NC
    Posts
    31

    Can't Assign Macro to Command Button??

    Hello experts!,

    I have a spreadsheet with a sendmail code and I'm trying to assign the macro to the command button (the grey box...on the toolbar), but it doesn't seem to be working?

    If I remember correctly..previously I would:

    left click the command button on the toolbar
    click an area on the spreadsheet, button appears.
    then right click and choose "assign macro".

    > Now I tried above and it doesn't work?
    > I had to use a "shape" in place of the command button..

    Can someone tell me what I'm doing wrong?

    ps - I have Excel 03'

  2. #2
    Registered User
    Join Date
    08-18-2008
    Location
    Singapore
    Posts
    79
    Hi Novice_704,

    By right it should work.

    Do you want to post the Excel document here so we could take a look?

  3. #3
    Forum Contributor
    Join Date
    10-01-2007
    Posts
    101
    1) right click on tool-bar
    2)go to customize on bottom of drop-down
    3)go to forms on left scroll menu
    4) go to "button" on right scroll menu
    5) drag "button" to toolbar
    6) left click on "button icon" in toolbar
    7) crosshair cursor should appear when you move cursor to sheet
    8) draw box
    9) computer will automatically ask you which macro you want to assign as soon as your done drawing box

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA help for a simple macro
    By wrc1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2008, 03:14 PM
  2. Macro is unlocking locked cells... but I didn't tell it to.
    By rziegler in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-08-2008, 06:22 PM
  3. Read-only error using Form Button with Assign Macro
    By samf88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-09-2007, 02:15 PM
  4. Assign 1 Macro to Run Multiple Checkbox Controls
    By Jay59 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-17-2007, 12:37 AM
  5. country finder lookup macro
    By theghost in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-07-2007, 10:41 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1