![]() This file will be created for you automatically when you choose "Personal Macro Workbook" from the Record Macro dialog box. You can always ask an expert in the Excel Tech Community or get support in Communities.This workbook will not exist until you have recorded your first macro AND closed and reopened Excel.Īny macros that are stored here will be available to run from any workbook. You can also make the workbook available on a shared network drive, or from a SharePoint Services library. If you have one, or just a few macros that you want to share with others, you can send them the workbook that contains them in an email. That folder for Mac is in the home folder at ~/Library/Containers//Data/Library/Application Support/Microsoft/Roaming/Excel/. If you want to share your Personal.xlsb file with others, you can copy it to the Excel home folder on other computers. For more information about copying a macro from one workbook to another, see Copy a macro module to another workbook. You can start the Visual Basic Editor in Excel by clicking Visual Basic in the Developer tab. If you want to copy macros from your personal workbook to another workbook or vice versa, you can do so in the Visual Basic Editor ( VBE). Save the changes, then close the workbook, and finally close Excel.Īny time you create a new macro and save it in your personal workbook, or update any macros already in it, you'll be prompted to save the personal workbook. On the Developer tab, click Stop Recording. On the Developer tab, click Record Macro. To create the personal workbook, you first need to create a macro and store it in the Personal Macro Workbook. Create and update the Personal Macro workbook In the Customize the Ribbon category, in the Main Tabs list, select the Developer check box, and then click Save. Before you get started, make sure that the Developer tab is available in the ribbon in Excel. Workbooks in the XLStart folder are opened automatically whenever Excel starts, and any code you have stored in the personal macro workbook will be listed in the Macro dialog, In Microsoft Windows XP, this workbook is saved in the C:\Documents and Settings\user name\Application Data\Microsoft\Excel\XLStart folder. In Windows 10, Windows 7, and Windows Vista, this workbook is saved in the C:\Users\user name\AppData\Local\Microsoft\Excel\XLStart folder. If you want to share your Personal.xlsb file with others, you can copy it to the XLSTART folder on other computers. You can start the Visual Basic Editor in Excel by pressing ALT+F11. If you want to copy macros from the personal workbook to another workbook or vice versa, you can do so in the Visual Basic Editor ( VBE). On the Developer tab, in the Code group, click Stop Recording.Ī message appears that prompts you to save the changes that you made to the Personal Macro Workbook.Īny time you create a new macro and save it in your personal workbook or update any macros that it contains, you are prompted to save the personal workbook just as it did the first time you saved it. Perform the actions that you want to record. In the Store macro in box, select Personal Macro Workbook. ![]() Make sure you don’t use any spaces in the name. In the Record Macro dialog box, type a meaningful name for the macro in the Macro name box. ![]() On the Developer tab, in the Code group, click Record Macro. See Show the Developer tab for more information. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |