Recording Macros When you need to quickly automate a task, you can record a macro using the Macro Recorder. Follow these steps: • Plan the actions you'll take in the macro. You may find it helpful to write them down so that you can perform them in the right sequence when recording the macro. • Launch Excel if it's not running, or activate it if it is running. • Set up a workbook with the conditions you need to perform the actions in the macro. For example, if the macro will move some data from one worksheet to another, enter some sample data to move, and make sure that the workbook contains a worksheet you can use as the destination. • Choose Developer Visual Basic Record from the Ribbon or Tools Macro Record New Macro from the menu bar to display.

Microsoft Office 2011 and Macros Posted on October 15th, 2010 by Peter James Microsoft Office 2011 is due out in about ten days, and one major feature added (well, actually returned) to the suite is the ability to write macros in Word and Excel. Download latest safari for mac. Oct 26, 2010 - Microsoft Office for Mac Home and Student 2011 Family Pack: Yes. Mode when you want to write macros, run macros that you previously recorded. Word, Excel and PowerPoint 2011 include Visual Basic for Applications.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

I am having problems with Word for Mac 2011. I have to edit copy supplied for a magazine, and the supplied copy is full of anomalies like double spacing, dashes where en rules should be, paragraphs indented with 4 spaces (instead of building the indent into the paragraph style), etc, etc. When I used a Windows machine I could press the record macro button and then start finding and replacing all of the (long) list of items that I needed to change. I then pressed the 'stop recording' button, and could then simply open the next document, run the macro and it cleaned up the copy in an instant. When I bought Microsoft Office for Mac 2011, I expected to do the same thing - but for some reason the macro will not run - or maybe only the first instruction. I have read somewhere that recording macros in Word for Mac simply does not work - but I find that hard to believe.

Surely a company of Microsoft's size would be able to fix that? I have also heard that it doesn't record mouse movements and clicks, so you have to record everything with keystrokes, but that is easier said than done (and a bit clunky, since there is no need for that on a Windows machine).