Results 1 to 4 of 4

Button on worksheet does not work

This is a discussion on Button on worksheet does not work within the Excel Questions forums, part of the Question Forums category; Hi All All I want to do is enable the button that I have added to a worksheet to run ...

  1. #1
    New Member
    Join Date
    Nov 2006
    Posts
    31

    Default Button on worksheet does not work

    Hi All

    All I want to do is enable the button that I have added to a worksheet to run the code but it just selects the button when I click on it
    as if I am still in developer mode.

    I am sure that there is easy fix.

    Thanks

    Jurassic Coast.
    UK.

  2. #2
    Board Regular
    Join Date
    Aug 2014
    Location
    Oz
    Posts
    152

    Default Re: Button on worksheet does not work

    The most likely reason is that you are in "Design Mode". There is a button on the Developer Tab to toggle it on/off.

    Another possible cause is last week's Windows Updates. There are some articles regarding this if you Google "command button stopped working". The solution that worked for me was to close all MS Office programs, and then search for .exd files. Then delete all the files that were found.

    Dan

  3. #3
    New Member
    Join Date
    Nov 2006
    Posts
    31

    Default Re: Button on worksheet does not work

    I thought that I had sussed it out by turning developer mode off by deselecting the 'Developer' option from the ribbon and closing and reopening the workbook but
    now I cannot get back to developer mode to edit the button.

    Does anybody know how this should work?

    Thanks

    Jurassic Coast
    UK

  4. #4
    MrExcel MVP Jonmo1's Avatar
    Join Date
    Oct 2006
    Location
    Bryan, TX
    Posts
    42,358

    Default Re: Button on worksheet does not work

    Perhaps it's related to this
    Office Update Breaks ActiveX
    Add-in for posting ranges as copyable tables (bottom of the page) -Win & Mac

    The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious.

    Life moves pretty fast. If you don't stop and look around once in a while, you could miss it.
    Ferris Bueller A.K.A. John Hughes, 1986

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com