Excel 2008 For Mac Macros

If you’ve recently upgraded to, you may like the productivity suite’s new features, but you may also face a few conundrums: some things just don’t work the way they used to, and others don’t work at all. We talked to Macworld editors and scoured newsgroups and forums to find out which problems were plaguing users. Here are answers to some of the most common questions that came up. Missing Macros Q: Why won’t my Office macros run anymore? A: Macros, which let you perform multiple actions with a single mouse-click or keystroke, can save a lot of time. But Office 2008 doesn’t support the Visual Basic for Applications engine that previous versions of Office used to run macros.

Aug 19, 2011 - I have Excel 2008 for Macbook. I'm trying to create a new Macro. I found it under Tools. However, I don't see the record button. How do I create. Aug 17, 2009  Hi I've just got a macbook and am transferring an excel sheet from pc to mac using office mac 2008. It won't recognise a macro i had in the sheet - can anyone help me to put this macro.

Wondering where your macros went? Office 2008 doesn’t support them. You’ll see this warning when you open a Word file that contains one. Now, if you open a file containing macros, you can choose to either remove or keep the (deactivated) macros (see “Macro Alert”). If you’re working on a file that you know a colleague has added macros to, don’t delete them—they’ll still work if someone opens the file with a different version of Office.

If you truly need to use macros to get your work done efficiently, you have only two choices. Office 2008 provides limited support for AppleScript and Automator, so you can write your own scripts or workflows, or find some to download. For some sample scripts for Word, see. What’s your other option? Stick with Office 2004 for now. In response to complaints, Microsoft has announced that the next version of Office for Mac will support macros, but that release is likely two or three years away.

X control for mac. Keeping Compatible Q: Why do my Word documents have the words “Compatibility Mode” in the title bar? A: All the Office 2008 programs use new default file formats. In Word, for example, the default file extension is now.docx instead of.doc. If you open a.doc file in Word 2008, the program lets you know that the file format is “compatible” with previous versions of Word but that it’s not taking advantage of all of Word 2008’s new features. If you plan on sharing files with people who don’t have Office 2008 (or Office 2007 for Windows), they won’t be able to open files that have been saved in any of the new file formats. In the programs’ Save dialog boxes, you can choose which format to use, and each program displays the compatibility of the older formats. You can change the default file format that Word and PowerPoint use for new files in either program’s Preferences menu.

In Word, for example, go to Word: Preferences, click on Save, and then choose Word 2007-2004 Document (.doc) from the Save Word Files As pop-up menu. Spaced-Out Paragraphs Q: Why is there extra space between paragraphs in my new Word documents? If you don’t like the extra space that now appears by default between paragraphs in Word, change the After setting in this window to get rid of it. A: By default, Word documents use the Normal style to determine the look of new documents. In Word 2008, that style includes a 10-point space between paragraphs.

While it’s probably better to use spacing like this than to add return characters, you can turn this feature off if you want. Choose Format: Style, select the Normal style from the list of styles on the left, and click on Modify. Then click on the pop-up menu at the bottom left of the window, and choose Paragraph.

In the Paragraph window that appears, go to the Spacing section and change the After field from 10 pt to 0 pt. If you’d like to leave the spacing in between paragraphs of different styles, don’t change this setting. Instead, select the Don’t Add Space Between Paragraphs Of The Same Style option. Click on OK and then on Apply to see your changes. Changing the Subject Q: Why has Entourage stopped letting me edit subject lines in the e-mail messages I receive?

A: Microsoft removed this feature from Entourage, but it seems to have done so unintentionally. To put it back, download the from the Entourage Help site.

Freeing Docked Toolbars Q: I used to keep my Excel toolbars on the side of open windows, instead of at the top. Why can’t I do this anymore? A: Microsoft decided to attach the most commonly used toolbars to the tops of windows, perhaps to make its programs look more like some of Apple’s programs.

Some toolbars sit in documents’ title bars by default. You can tell which ones by choosing View: Toolbars. The submenu contains a separator; the toolbars above the line stay attached to the title bar, and the rest float as before.

However, with the exception of each program’s Standard toolbar, you can control-click on any toolbar and deselect the Dock Toolbar In Window option to make it float again. (You can also make this change by choosing View: Customize Toolbars And Menus and then deselecting the Dock option for any of the toolbars that allow this.) As for the Standard toolbar, you can make it disappear by selecting View: Toolbars: Standard, but if you want to get it to float, you’ll need to create your own toolbar and copy some or all of the Standard toolbar’s buttons. Custom toolbars you create are not docked in the program’s title bar. To do this in Excel, PowerPoint, or Word, choose View: Customize Toolbars And Menus. (You can’t customize the toolbar in Entourage.) Click on New to create a new toolbar.