+ Reply to Thread
Results 1 to 3 of 3

ActiveX CommandButton Stopped Wroking

Hybrid View

  1. #1
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    ActiveX CommandButton Stopped Wroking

    This is a small portion of a large workbook I have received from someone in my company.
    I am asked to write some summary reports etc.

    Anyway, the original file has these comandbuttons that seem to stop working at times.
    The attached file has two worksheets and the button on "C1" worksheet should take you to "Input" sheet but it doesn't do anything. And the button on the "Input" sheet at Cell address "U7" is supposed to take you to Sheet "C1".

    I am not too familiar with ActiveX buttons, so I would appreciate any help I can get.

    Thanks,
    modytrane.
    Attached Files Attached Files
    Last edited by modytrane; 05-19-2011 at 10:41 AM. Reason: solved

  2. #2
    Forum Contributor
    Join Date
    05-09-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    315

    Re: ActiveX CommandButton Stopped Wroking

    That's because your code isn't behind your buttons. For example, the button on sheet C1 is called CommandButton1 but the code is behind a button called inputsheet (which doesn't seem to exist). Either rename your button or move the code.

    Dion

  3. #3
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: ActiveX CommandButton Stopped Wroking

    Thank you for your response.
    I have fixed the problem.
    It is still a mystery as to how that got changed.
    Anyway, Thanks again.
    modytrane.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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