What if I’m Unable to Record a Macro in Personal Macro Workbook The recommendation is to take a back of the Personal Macro Workbook so that you can restore it in future. All you need to do is, open the Excel STARTUP folder and delete the file from there.Īnd if the PERSONAL.XLSB file hidden then you simply unhide it and then delete it. If you don’t want to have a Personal Macro Workbook you can simply delete it from your system. If the new system where you want to transfer all the codes don’t have a Personal Macro Workbook then you can simply copy-paste personal.xlsb from the old system to new system’s Excel startup folder. (B) Copy-Paste Personal.xlsb File to the Startup Folder Now, you have the new module in your Personal Macro Workbook where you have all the VBA codes and you can use them from the macros list. After that, browse the module file and click OK to import.For this, open VB editor and right click on the “Personal.xlsb” and select the “Import File”.Next, you need to import this module not the VB editor at the new system.
Below are the steps you can use to do this: The best way to share or transfer your Personal Macro Workbook is to export the VB module from one system and import it in the other system. Now in this situation, you can use do the following things: (A) Export and Import the Module It happens sometimes when you need to share your macros from Personal Macro Workbook with others or you just need to transfer it to a different system. Can I Share My Personal Macro Workbook with Others? You can store all those codes your personal workbook and can use them from any workbook on your system.Īs I said when you open your Excel the “PERSONAL.XLSB” open with it so your codes will be accessible all the time when you are using Excel. Well, if you love to use macros and have some useful codes which help you do your stuff with a click you must have a Personal Macro Workbook. Why Should I have a Personal Macro Workbook?
0 kommentar(er)
