Button on worksheet does not work

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Button on worksheet does not work

  1. #1
    New Member
    Join Date
    Nov 2006
    Posts
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    37
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    43,485
    Post Thanks / Like
    Mentioned
    14 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Button on worksheet does not work

      
    Perhaps it's related to this
    Office Update Breaks ActiveX
    Use the MrExcel HTML Maker to post nicely formatted tables in your forum posts.
    Find a link in post number 31

    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

User Tag List

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