+ Reply to Thread
Results 1 to 5 of 5

Greyed out buttons in Excel 2011's Visual Basic Editor on Mac

  1. #1
    Registered User
    Join Date
    02-28-2013
    Location
    United States
    MS-Off Ver
    Excel 2011
    Posts
    3

    Greyed out buttons in Excel 2011's Visual Basic Editor on Mac

    Hi! I just started a VBA for Excel class and am having problems writing in Visual Basic Editor (VBE). I have enabled the 'Developer' tab and can open the VBE, however, nearly every button in VBE is greyed out. I cannot Insert-->Module or nearly anything else. I cannot even type in the box. If I click the 'Macro' button on the Developer tab to add a new Macro, I can type in the name and click 'Create' but then nothing happens and it is not saved (at least I think it's supposed to save it or something). Any help will be appreciated!!! I will try and reply anything you suggest. Thanks!

    I am using Excel 2011 on a 2012 MacBook Pro.

  2. #2
    Registered User
    Join Date
    02-28-2013
    Location
    United States
    MS-Off Ver
    Excel 2011
    Posts
    3

    Re: Greyed out buttons in Excel 2011's Visual Basic Editor on Mac

    Here is a shot of my screen if it helps: http://i.imgur.com/fjkDcdi.png

  3. #3
    Registered User
    Join Date
    04-25-2013
    Location
    Utah
    MS-Off Ver
    Excel for Mac 2011
    Posts
    7

    Re: Greyed out buttons in Excel 2011's Visual Basic Editor on Mac

    I'm having this same issue. Did you or anyone else ever figure out the problem? I open the Visual Basic Editor (Excel 2011 on Mac) and the 3 icon buttons across the top are all greyed out. Not sure what I need to do to enable those buttons. Any help would be much appreciated!

    Thanks,
    jnlong

  4. #4
    Registered User
    Join Date
    02-28-2013
    Location
    United States
    MS-Off Ver
    Excel 2011
    Posts
    3

    Re: Greyed out buttons in Excel 2011's Visual Basic Editor on Mac

    I do not remember how I fixed it! I think I ended up using someone else's computer. Have you tried restarting your computer? Can't remember if that helped... But I did use it again. I may have been in the wrong window or something...Sorry! Good luck!

  5. #5
    Registered User
    Join Date
    04-25-2013
    Location
    Utah
    MS-Off Ver
    Excel for Mac 2011
    Posts
    7

    Re: Greyed out buttons in Excel 2011's Visual Basic Editor on Mac

    Thanks for your reply.

    I came across this page which might explain why the Visual Basic Editor is disabled.

    http://support.microsoft.com/kb/282847

    So now the challenge is how do I enable it? If I find an answer, I will be sure to post for the next person who runs into this same issue

    - jnlong

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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