Where to find excel macro file

Doing this would show a prompt as shown below:. XLSB file in the start folder, where it would automatically open in the backend whenever you open Excel. XLSB file is created and saved, you can copy macros that you wish to reuse again. Suppose you have a list of macros saved in the Personal Macro workbook and you want to use it on a new Excel file you get.

Note that the macro dialog box shows you the list of all the macros that are available for use in the open workbook. This would include the macros stored in the workbook as well as the ones stored in the Personal Macro Workbook.

Thanks a lot! Thanks for your so much favour,Puneet can you tell me code to split column category wise like we have written Category as column header and under it we have data that like department accounts,store,complaints etc. If the file does not delete, that means it's still running in the background. To fix this, open the Task Manager and kill all running Excel processes.

That's how to make your favorite Excel macros available in all workbooks. I thank you for reading and hope to see you on our blog next week! Personal Macro Workbook in Excel - make macros available in all workbooks by Svetlana Cheusheva updated on March 2, What is Personal Macro Workbook? Where is my Personal. How do I create a personal macro workbook in Excel? How do I edit a personal workbook in Excel? How to I run macros from personal workbook?

How do I export my personal macro workbook? How do I share my personal macro workbook? How do I enable a personal macro workbook? How do I stop Personal. How do I unhide a personal workbook in Excel? How do I delete the Personal. Your Personal. If you want to share your macros with someone else, you can copy it to the XLSTART folder on other computers, or copy some or all of its macros to the Personal.

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. You can also make the workbook available on a shared network drive or from a SharePoint Services library. For more information about copying a macro from one workbook to another, see Copy a macro module to another workbook. Make sure the Developer tab is visible on the ribbon. By default, the Developer tab is not visible, so do the following:.

If you want to share your macros with someone else, you can copy Personal. In Finder select Go , then hold down the Option key, and select Library. Paste your Personal. You can always ask an expert in the Excel Tech Community or get support in the Answers community. Go to the Developer tab, and click Record Macro. Need more help? Just to build on swridings answer and have it paste that path to a cell so you can copy and paste it into the explorer, see below:. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Where is your personal macro workbook located? Ask Question. Asked 4 years, 5 months ago. Active 2 years, 8 months ago. Viewed 53k times. Improve this question.

Community Bot 1 1 1 silver badge. Scott Ridings Scott Ridings 1 1 gold badge 5 5 silver badges 13 13 bronze badges. UGP--it's crystal clear, if you know the name of said workbook is personal.