![open personal macro workbook excel 2016 open personal macro workbook excel 2016](https://www.theexceladdict.com/images/individual_tips_page_banner.png)
But in MSO2010, there is no such "pathway" or screen. The solutions that were offered (in other threads of TSG) for 2007 proposed going to About > AddIn and enabling the. When I navigate to that directory\file and examine the file properties, it says "Enabled". This is the path given in the Help command for "Pesonal Macro Workbook". XLSB file in my Excel is:Ĭ:\Users\\AppData\Roaming\Microsoft\Excel\XLSTART Since then, I tried a couple of times to record another macro (with PMW.
![open personal macro workbook excel 2016 open personal macro workbook excel 2016](https://media.gcflearnfree.org/content/563d05f9ca7fac0d9c7b3f7e_11_06_2015/creating_opening_onedrive.png)
I am currently able to use the one macro that I recorded when my PMW had the default extension. It seems that (at least my copy of) MS Office/Excel is different from what would be expected by the suggestions you offered earlier (and that previous threads seem to have proposed for Excel2007).
![open personal macro workbook excel 2016 open personal macro workbook excel 2016](https://www.repairmsexcel.com/blog/wp-content/uploads/2020/10/Personal-Macro-Workbook-Fails-To-Load.png)
I am rather out of my depth with this problem of the Personal Macro Workbook (PMW). Garf, I very much appreciate your time in trying to help me here. Or at least an explanation as to why the use of.
#Open personal macro workbook excel 2016 how to
I would appreciate an explanation how to make Personal.XLSB open as it should.
#Open personal macro workbook excel 2016 windows
The setting is now "Opens with: Windows Shell Common" I find that the "open with" setting was changed when the extension was changed However, I do not like using workarounds, as they can cause trouble later. The Personal.XLSA file opens with Excel and the macros are available.īut the file seems to be grayed out when viewed with Explorer in /XLSTART/ *rename the Personal.XLSB to Personal.XLSA However, the Personal.XLSB file can be opened and the macro made functionalīy manually opening that file where it is stored in /XLSTART/Īn unexplained workaround was identified in the closed thread. a desktop shortcut to a specific Excel file Same not-opening result, whether opened by clicking on When Excel is opened, the Personal.XLSB DOES NOT OPEN WITH it.īecause the Personal Macro Workbook does not open, (It also contained the same steps macro before it was deletedĪnd re-recorded during troubleshooting for this problem.) The file contains a (freshly re-made) macro. The file properties option "Opens with Excel" is selected. The Personal.XLSB file is in the correct location /XLSTART/ The "Personal Macro Workbook" is a file called Personal.XLSB