How To Install An Excel Add-in in Excel 2011 for Mac This page will guide you through installing an Excel add-in file for Excel 2011 for Mac. Installation instructions for the Windows versions of Excel can be found here. Excel lets me 'record' the macro but then nothing happens when I run it.” Where is it the “nothing happens”? Can you see the formatting in Excel, on the screen,.
After reading all the great things about Microsoft Excel for Mac 2011 that were written before its release, I decided to purchase a copy. My primary goal was to have an Excel version on my MacBook Pro that allowed VBA macros, however the full Office software suite seemed to be a really great value. I paid $174.99 USD for the edition on amazon.com after pre-ordering and receiving a $25 discount from their price assurance guarantee.
Excel 2011 Software Installation What you get with the Office 2011 Home and Business Edition:. Word 2011. PowerPoint 2011. Excel 2011. Outlook 2011. Microsoft Office Web App support. Messenger for Mac 8.
Remote Desktop for Mac 2 (drive your Windows-based PC from your Mac). Technical support 1 year The installation took about 15 minutes. The program loaded, I entered the product key, activated and registered the software, then launched Excel, and got a welcome screen telling me all about the new.
And then I had to face the Excel Workbook Gallery, which is the default screen that appears when you open Excel 2011. Nice for all of 15 seconds. At the bottom of this screen there’s a box you can check: Don’t show this when opening Excel, but I ignored it and went straightaway to a blank Excel workbook. Excel 2011 Preferences The first thing I wanted to check out was the Options, oops pardon my Windows speak, I mean Preferences, by using the menu selection Excel → Preferences or the keyboard shortcut Cmd+apostrophe ( ⌘, ). Within these preferences is standard stuff you’d find in a Windows version of Excel, but I want to review some of the settings for General, Edit, AutoComplete, Compatability, and Ribbon. General Preference In the General dialog box I unchecked the box beside: Open Excel Workbook Gallery when application opens so that Excel opens to a blank worksheet.
Edit Preference On the Edit dialog box, a new option for Excel 2011 is Automatically convert date system. As you can see in the Description box below, this option converts the date system of the source data to match the date system of the target workbook. I’m not exactly sure how this preference option works and will be looking into it, but with (1900 & 1904) this setting becomes more important now that Excel 2011 and Excel 2010 can share workbooks on the web in. AutoComplete Preference In the AutoComplete dialog box the setting for Show the menu only after I’ve typed x letters (x set at 1, range 0-9) seems to be one that I’ll revisit soon.
I’m not sure I want AutoComplete popping up after typing only 1 letter. CompatibilityPreference On the Compatibility dialog box, under Transition, the Save files in this format: is defaulted to Excel Workbook (.xlsx) and can be set to a number of different things. Changing the default file format to Excel 97-2004 Workbook (.xls) might be prudent should you share files frequently with people using older versions of Excel. Ribbon Preference On the Ribbon dialog box, under Show or hide tabs, I noticed that you can drag them in the order you prefer. I added the Developer tab to the Excel Ribbon by checking the box for Developer.
The VBA Editor – A Quick Look I had to peek at the VBA editor just to check it out. Going to the Developer tab and clicking Editor opened the VBA Editor, where I added a module and wrote a quick test macro, as you can see below. Not a bad start. Next I’ll compare the Ribbons of Excel 2011 and 2010. Post author My auto-complete works, sort of. It’s not like Windows where an auto- complete word is highlighted entirely and you can hit enter to, well, enter the matched word. In Excel 2011 any match shows up in a list below the cursor and I have to hit the down arrow to select the word, then hit enter to enter the word.
Too much work and very annoying. Sometimes auto-complete won’t work if there are blank cells in the column of data, but I’ve not had the problem you’re describing. I just typed in “apple” in cell A1 and “brainiac” in cell A1, then in cell A3 typing a letter a or b gives me the auto-complete functionality. praktisches-wissen I had the same problem, that autocomplete worked, and than no more. And now it works again. (But unfortunately I can’t tell what I did that made it working.) What I did, was I just rechecked all the options as above mentioned; worked through all functions keys (if that helped I do not know) – and “magically” the autocomplete refunctioned again.) BTW: Personally I prefer the way Excel Mac 2011 offers the entries – it’s a better way to offer all possible entries and then being able to select them by arrow down and enter.
Post author Drop-down menus using data validation should work in each version. If the drop-down menus in Excel 2010 are ActiveX controls, they won’t work on a Mac in Excel 2011. You could change them to Form control menus, which would work in Excel 2011 on a Mac. I have no idea why the formulas would be protected or hidden.
Without seeing the file or a sample of the issues you are facing its hard to determine the cause of any problems. If you would send me a sample file (using the form on the contact page) I could give you a better answer since I have a Mac and a PC with different versions of Excel. Post author Macros created in Excel 2007 on a Windows PC may, or may not work in Excel 2011 on a Mac. There are some minor differences in the code that may cause an error, but generally the code should work. The quickest way to find out is to run the macro and find out if there are any errors.
To run a macro in Excel 2011 on a Mac use the keyboard shortcut Fn+Option+F8 (or just Option+F8 if you’ve changed the Fn preference) to bring up the Macro dialog box. You can also run a macro from the Developer tab on the Ribbon. If you don’t see the Developer tab, choose Excel Preferences and click Ribbon, then select the check box before Developer and click OK. Jim Hahn 1) I know there is a way to change/add keyboard shortcuts for Excel for Mac 2011.
Is there a way to change/add keyboard shortcuts for the VBA side? There are just too many keys to hold down to do basic debugging. E.g., shift+command+I to “step into” from a breakpoint. I can’t see a way to change shortcuts. 2) Assuming, apparently incorrectly, that I could change VBA shortcuts, I made an exhaustive list of all command+letter shortcuts to see what might be available to use for debugging commands. While doing this, I found that command+J appears twice.
Once for “list properties” and once for “bring to front”. How can one shortcut do two different things? Maybe it’s smart and context sensitive. 3) I am hung up on simple debugging, so bear with me. I found that there are special keyboards called ‘chorded keyboards’ which allow one to type all the keys on a standard keyboard with one hand on a keyboard with only a ‘few’ keys. I am not sure why anybody would want that, but that’s beside the point. Here’s my question: Does anyone know of a hardware keyboard with, say, a 4×4 row of fat buttons on it.
Each button could be programmed to issue commands like “step into” or “step over” or whatever you wanted. The existing chorded keyboards I can find are weird shaped with buttons in odd placesnot too useful for what I want. Thanks for the great web site.
Pryce I have a MacBook Pro with Lion 10.7.3. I am also running Fusion 4.1.1. I have several spreadsheets created on the PC (Windows) Excel (older versions) that are workbooks with several tabs and Macros that have been set up to run various programs.
Was considering buying 2011 Excel for Mac, but was worried about running the older excel programs with Macros on the Mac side. Was going to buy the 2010 Home and Student version for PC so I wouldn’t run into problems with the Mac side. I am sharing programs with PC users, so I need to be totally compatible with the PC when running and revising programs. Do you think the 2011 Mac version will be ok for me, or should I buy the PC version to be safe?. Post author I would get the PC version to be safe.
Even though Excel 2011 (Mac) allows VBA code, it doesn’t allow any ActiveX Controls. You can use Form Controls in both versions, but you have to KNOW which control you have in the older Excel (windows) file because they look similar on first appearance. A drop-down combo list control, or a button could be either type unless you check the properties. ActiveX controls can be replaced by Form controls, but this takes effort and sometimes there is a good deal of code in the ActiveX control that has to be moved to a module. Post author Go into the VBA Editor (Alt+F11) choose View Project Explorer, and see if there are worksheets under the Microsoft Excel Objects.
If so click on one of the sheets, then choose View Properties Window and check the Visible Property. It will be one of three values: -1 – XlSheetVisible 0 – xlSheetHidden 2 – xlSheetVeryHidden You can change this property to the first one and the sheet will appear in the workbook. Any of the sheets that are xlSheetVeryHidden don’t show up in the Hidden sheet dialog box and will appear almost invisible to most users.
Patrick need help with macros they run great then they dissappear re appear stop working and now give me 1004 error messages about refresh backrounddata excel cannot find the file etc. At this point Will pay for help need excel for mac to prompt user to find a csv file open with certain presets especially certain columns formatted as text so we keep leading zeros copy the data to existing or new spreadsheet and be able to do that action in any new work book or template we use. HAd it working now its stopped. So i think one more step is to never link bak to that data file once i paste it in excel i want the dat to stay static unit i chang sit.
I am using Microsoft Excel for Mac 2011, version 14.2.3, and trying to record some simple macros to consolidate/move data. Under the developer tab, when I hit the record button, it appears that I can record and proceed with my key strokes for the actions I want to perform.
After my keystrokes of moving data, I then hit the record button again to stop thinking I've recorded a macro. When I go to run my macro, nothing happens. If I then look under the Editor to see the programming for my macro I just recorded, nothing has recorded other than what I named the macro. No keystrokes appear.
Does anyone have any thoughts or suggestions? Code: Sub Macro3 ' ' Macro3 Macro ' ' Keyboard Shortcut: Option+Cmd+Shift+A ' Selection.Copy Sheets.Add Sheets('Sheet2').Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= False, Transpose:=False End SubPressed the round red 'Record' button Said button became a black square (a stop if you will). Did the 'copy from sheet1, paste into sheet2' routine then pressed the black square and it became a red 'record' button again. Then pressed the icon on the left of 'record' named 'Macros' and the code corresponding to the steps stated above would appear.