Open up the Forms and Modules areas to see what is there. Now find the file that you just opened which has the macros in it. If not, choose View > Project Explorer to display it. Make sure that the Project Explorer is visible on the left of the screen. Now locate the Developer tab and click the Visual Basic button to open the Visual Basic Editor.
In Word 2010 to show the Developer tab on the Ribbon, choose File > Options > Customize Ribbon and in the right hand panel, make sure that the Developer option has a checkmark against it. In Word 2007 to show the Developer tab on the Ribbon, choose the Office Button > Word Options and then from the Popular group, select Show Developer tab in the Ribbon. To do this, first open the file that contains the macro code, then make sure that the Developer tab is visible. If you have a macro in a Word document then you need to move the macro to your Normal.dotx file. When this is the case, you need to move the macro into a file that gives you access to that macro at any time in future. On the other hand, many macros are ones you will want to use over and over again with all sorts of files. Macros which fall into this category include macros that are specific to a particular worksheet which wouldn't make sense used elsewhere. In some cases, a macro will be designed only to run within the current file and it won't be a macro that you would want to use in all files. So you can use these macros every day for your own work you will need to move them into a file that is open every time automatically for you.įor example, I write two macros every month for Techlife magazine in Australia – these are Word, Excel or PowerPoint macros and they are delivered in a Word document, an Excel Worksheet or a PowerPoint file. Often you will get a macro delivered to you in a document or worksheet.
0 kommentar(er)
