+ Reply to Thread
Results 1 to 3 of 3

Command Buttons don't work

  1. #1
    Registered User
    Join Date
    06-22-2018
    Location
    Clanfield
    MS-Off Ver
    2013
    Posts
    42

    Command Buttons don't work

    hi, i wonder if anyone got an idea of what could have happened... I have excel spreadsheet that have UserForm that is enabled upon pressing Command Button. All worked fine but for some reason my colleague now cannot use these buttons. Basically, there is no reaction from Command Buttons when she pressed them. IT was working absolutely fine recently but all of the sudden it stopped. Moreover, all works OK when you run the codes from the Developer codes so it's clearly a matter of some sort of settings in her Excel that disable her Command buttons.

    I will add that everything else works perfectly fine for other users of this spreadsheet. As you can guess Company IT is useless..... any ideas what has happened and why??

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Command Buttons don't work

    I'd suspect you are using ActiveX command buttons - switch to Form ones if you can (or a Shape with a macro assigned if you want more formatting options). ActiveX controls are prone to these issues when different machines have different patches applied.
    Rory

  3. #3
    Registered User
    Join Date
    06-22-2018
    Location
    Clanfield
    MS-Off Ver
    2013
    Posts
    42

    Re: Command Buttons don't work

    Quote Originally Posted by rorya View Post
    I'd suspect you are using ActiveX command buttons - switch to Form ones if you can (or a Shape with a macro assigned if you want more formatting options). ActiveX controls are prone to these issues when different machines have different patches applied.
    that's great! Work perfectly now... thank you very much

+ 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. Data Validation and Command Buttons or Form Buttons
    By rededdie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-20-2019, 03:48 PM
  2. use a command button to click other command buttons
    By fcharl9 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2013, 08:48 PM
  3. Useform Code - 12 Command Buttons dependant on other command buttons
    By darrenkaye in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2013, 10:58 AM
  4. Master Command Button to call on other Command Buttons located in other Workbooks
    By MrNickRegan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2013, 07:57 PM
  5. Code for a master command button to change the backcolor of multiple command buttons?
    By panttherm5 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2012, 10:11 PM
  6. Linking command buttons to option buttons
    By sealtite01 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-20-2012, 12:25 PM
  7. command buttons:label of a command button
    By stoney1977 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2008, 07:16 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