+ Reply to Thread
Results 1 to 1 of 1

Include ActiveX Command Button in Tab Order

  1. #1
    Registered User
    Join Date
    07-05-2017
    Location
    Salt Lake City, UT
    MS-Off Ver
    2016
    Posts
    3

    Include ActiveX Command Button in Tab Order

    In the attached spreadsheet, I am wanting to include the ActiveX buttons in the tab order when the sheet is protected. I would also like the ability to use the enter key to select each button when selected.

    I understand that a userform or frame would have been a solution this issue, but that would require me to rework the existing code. I'm wondering if there is a VBA workaround with what I already have, so I don't have to start from scratch.

    I have searched high and low, and this was the closest solution I could find:

    https://www.mrexcel.com/forum/excel-...out-macro.html

    The last comment on that thread seems to be the answer I am looking for, but the code is overly complex. Any help appreciated!!
    Attached Files Attached Files

+ 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. ActiveX Command Button combined with ActiveX List Boxes – VBA Code Needed
    By Stlcards13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2017, 02:56 PM
  2. Inserting Row Macro using Command Button (ActiveX) relative to Button
    By mebailey in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2016, 09:17 PM
  3. ActiveX Command Button
    By kwrigh6 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-17-2015, 09:56 AM
  4. Run activex command button via macro
    By dhaval123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-20-2013, 06:07 AM
  5. [SOLVED] ActiveX command button error on Mac!!!
    By devpp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-26-2013, 03:09 AM
  6. [SOLVED] Editing a Command Button - ActiveX?
    By Jennster in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2012, 08:19 AM
  7. ActiveX command button
    By Dr.Schwartz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-14-2005, 04:05 PM

Tags for this Thread

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