Sunday, April 07, 2019

Where Is Your PERSONAL.XLSB (Personal Macro Workbook) Located?

For a change, Google didn't just spit out the answer right away..


What you do :

  1. Make it visible (View Tab > Unhide > PERSONAL)
  2. Press F12

And you get to see.. In my case :

C:\Users\<name>\AppData\Local\Packages\Microsoft.Office.Desktop_weirdbuchofchards\LocalCache\Roaming\Microsoft\Excel\XLSTART

No comments: