Excel User Form Controls Not Working

Posted on 2011-10-17
Last Modified: 2012-05-12
I opened up my userform today in Excel, and none of the control buttons are working.  I clicked on each one of them and nothing happened.  Any thoughts?
Question by:mato01
    LVL 85

    Expert Comment

    by:Rory Archibald
    Is the code still there?
    LVL 27

    Accepted Solution

    Have macros been disabled?  This could have been changed at a global level, if not just the workbook.
    LVL 11

    Expert Comment

    I think Glenn is likely right.  I'm not sure what version of Excel your using (I wish everyone included that in questions)

    But for Excel 2010 check here:

    File>Options>Trust Center>Trust Center Settings>

    I'd check your settings there.  

    LVL 85

    Expert Comment

    by:Rory Archibald
    How would the form be running with macros disabled?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now