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.
Bookmarks