+ Reply to Thread
Results 1 to 2 of 2

"assign macro" option for a command button not always in menu

  1. #1
    Registered User
    Join Date
    03-17-2011
    Location
    Iowa City, IA
    MS-Off Ver
    Excel 2007
    Posts
    27

    "assign macro" option for a command button not always in menu

    all,

    I have two XLS files and with one of them, this menu is there and one of them it isn't. I'm not sure why this is happening, although the file that does *not* have the menu option available began as a XLSM file. I re-saved it as an XLS. What am I missing here? It's been a while since I worked with Excel in depth...

    see attached images for what I'm experiencing.

    thanks.
    Attached Images Attached Images

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: "assign macro" option for a command button not always in menu

    the one that doesn't have the menu is an activex commandbutton and not a forms button-you do not assign macros to activex buttons but use their click (and other) events instead
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ 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. Create a Command Button to "Save As" and "Close" an Excel Workbook
    By thedunna in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-26-2013, 05:38 PM
  2. [SOLVED] (updating inventory using user form) : Assign macro to "Çheck Availibility" command button
    By pyol17 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-08-2012, 06:50 AM
  3. Add command button to assign "shortcut" macros
    By menksa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2008, 08:43 AM
  4. [SOLVED] "assign macro" not an option from short menu
    By SteveJ in forum Excel General
    Replies: 2
    Last Post: 05-18-2006, 01:00 PM
  5. Stop users from accessing "Protection" option from "Tools" menu
    By I Believe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2005, 10:50 AM

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