Forum Discussion
Solved
Unable to see new Personal Macros in new workbook
I have a coworker who is having a problem with their personal workbook. I tried it on my computer and I'm having the same problem. So, I do not believe it is specific to their computer. I go t...
- Perhaps your personal workbook is not opening when you open/create another workbook.
here are the steps you need to make sure are done, in order for your macros to be visible.
1- First place your macros in a file.
2- make sure that your Macros are not "Private Sub"
3- once you placed your macros in the file, then under the view tab click "Hide" ( you do this becuase when your personal workbook opens, it does not the workbook itself)
4- Now, you need to save the workbook with the xlsb or xlsm format and place it in the following start up directory C:\Users\YourUserName\AppData\Roaming\Microsoft\Excel\XLSTART
Replace the YourUsername to your login account name.
5- now you are all set. when you open any workbook, whether new or an existing other workbook, the personal workbook opens but you will not see it, as it is hidden, but all your macros will be showing in the macro section.
Hope this helps.
Perhaps your personal workbook is not opening when you open/create another workbook.
here are the steps you need to make sure are done, in order for your macros to be visible.
1- First place your macros in a file.
2- make sure that your Macros are not "Private Sub"
3- once you placed your macros in the file, then under the view tab click "Hide" ( you do this becuase when your personal workbook opens, it does not the workbook itself)
4- Now, you need to save the workbook with the xlsb or xlsm format and place it in the following start up directory C:\Users\YourUserName\AppData\Roaming\Microsoft\Excel\XLSTART
Replace the YourUsername to your login account name.
5- now you are all set. when you open any workbook, whether new or an existing other workbook, the personal workbook opens but you will not see it, as it is hidden, but all your macros will be showing in the macro section.
Hope this helps.
here are the steps you need to make sure are done, in order for your macros to be visible.
1- First place your macros in a file.
2- make sure that your Macros are not "Private Sub"
3- once you placed your macros in the file, then under the view tab click "Hide" ( you do this becuase when your personal workbook opens, it does not the workbook itself)
4- Now, you need to save the workbook with the xlsb or xlsm format and place it in the following start up directory C:\Users\YourUserName\AppData\Roaming\Microsoft\Excel\XLSTART
Replace the YourUsername to your login account name.
5- now you are all set. when you open any workbook, whether new or an existing other workbook, the personal workbook opens but you will not see it, as it is hidden, but all your macros will be showing in the macro section.
Hope this helps.
Yes, this worked. The key was to check if the PERSONAL file already existed in that directory and move or delete it. Then, open the macro file and hide it. Then save the file to that folder. It took a couple tries to get the sequence correct, but it then worked as I hoped. This made my day. Thanks again!
