kanadaaa
Active Member
- Joined
- Dec 29, 2019
- Messages
- 348
- Office Version
- 365
- Platform
- Windows
Hi, I have a question about Personal Macro Workbook.
I'm planning to customize the Ribbon and make some tabs for macros, and I want to add macros from Personal Macro Workbook.
So I created one by recording a macro, and now I want to find PERSONAL.XLSB because the workbook I'm working on now will be distributed to other people.
But when I go to %Appdata%\Roaming\Microsoft\Excel\XLSTART (my OS is win10), I don't see any file, as in the picture below.
This is the path that the immediate window gave me when I asked "?ThisWorkBook.Path".
Any idea why this happens? Thanks for your help in advance.
I'm planning to customize the Ribbon and make some tabs for macros, and I want to add macros from Personal Macro Workbook.
So I created one by recording a macro, and now I want to find PERSONAL.XLSB because the workbook I'm working on now will be distributed to other people.
But when I go to %Appdata%\Roaming\Microsoft\Excel\XLSTART (my OS is win10), I don't see any file, as in the picture below.
This is the path that the immediate window gave me when I asked "?ThisWorkBook.Path".
Any idea why this happens? Thanks for your help in advance.
Last edited: