When I saved an Excel 2011 workbook with a custom toolbar on one Mac, and transferred it to another, the toolbar did not appear. When I coied the Microsoft Excel Toolbars.xlsx file over (and dropped it in the proper location), the toolbar did appear. Excel 2011 Quick Reference Card Excel 2011 Screen Keystroke Shortcuts General Open a Workbook + O Save a Workbook + S Print a Workbook + P Close a Workbook + W Undo + Z Redo or Repeat + Y Minimize Window + M Navigation Move Between Tab Unlocked Cells Up One Screen Page Up Down One Screen Page Down.
For years, Excel 2008 has been teasing me: Every time I launched the app, I’d see that menu item, mocking me, tempting me to click. “Go ahead,” it would whisper, “You know you want to.
This time it’ll work—really, it will.” But selecting Tools - Macros in ( ) would only remind me, once again, that the Macros menu was but a mere shell of its former Excel 2004 self. It seemed to exist for no other reason than to annoy those of us who used and relied on Visual Basic for Applications (VBA) macros. Sure, that menu might show you some really old macros, the ones written in the Excel 4.0 macro language. But it wouldn’t show you anything written with VBA. And if the sheet you were looking at included VBA macros, they wouldn’t run.
Excel 2008's macro window: sadly, empty.“But what about AppleScript,” you ask? Sure, Excel 2008 supported. But AppleScript couldn’t really replace the functionality of VBA. You couldn’t, for example, use AppleScript to change Excel’s menu structure, to manage a data-input form, or to change spreadsheet values on the fly—all things you could easily do with VBA.
Now, with the release of ( ), Microsoft has brought VBA support back to Excel for the Mac—and the Tools - Macro menu item is once again useful. Old and new In my testing so far, Excel 2011 runs older macros just fine. I opened one macro-laden worksheet I’d created back in 1992 in Excel 2011; it ran perfectly.
![Edit toolbar excel 2011 for mac download Edit toolbar excel 2011 for mac download](http://www.softsolutionworks.com/images/ExcelMac/Excel_VisualBasic.jpg)
I also opened a number of Excel 2004 worksheets, all of which used macros to some degree or another, and they also worked as expected. New macros I’ve recorded so far all worked as expected. The Visual Basic Editor’s work area is mostly identical to that of Excel 2004’s, but with a few nice additions. For instance, the Edit menu features some new options for viewing properties, methods, constants and parameters.
In the Debug menu, you can create Watch functions, which allow you to watch an expression and to stop the macro when a value changes or a condition becomes true. Microsoft’s Excel 2011 team has also worked to make Mac macros compatible with those written for Excel for Windows. According to Microsoft, Excel 2011 for Mac features a full port of the Windows Office VBA environment; in most cases, the OS X and Windows versions of VBA now mirror each other.
This includes updating the core VBA engine in Office 2011 to VBA version 6.5, and adding some commands (FormatCurrency, FormatNumber, Replace) that had been disabled in Excel 2004 for the Mac. When there were object-model differences between the Windows and OS X versions, Microsoft says it conformed the Mac version to Office 2010. (Macworld hasn’t had the opportunity to fully test that Windows-compatibility yet.) Overall, I’ve been quite happy with the macro experience in Excel 2011. Now that Tools - Macros does something useful once again, I can finally retire Excel 2004.
![Excel Excel](/uploads/1/2/5/4/125427117/986142208.png)
Yup, same problems here with toolbars not working, disappearing, etc. Then I saw another contributor's suggestion about finding and revising the.plist file for Word (in the library folder).
The.plist is just the personal preferences you set for an application. When I had problems long ago with Word, the support tech told me the file probably got gotten corrupted, so just drag it into the Trash.
Word automatically generates a new preferences file with the default settings. Only problem is that you need to reset your preferences, but it works. Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums.
Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.