SOLVED
Home

Unable to see new Personal Macros in new workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-455154%22%20slang%3D%22en-US%22%3EUnable%20to%20see%20new%20Personal%20Macros%20in%20new%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-455154%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20coworker%20who%20is%20having%20a%20problem%20with%20their%20personal%20workbook.%26nbsp%3B%20I%20tried%20it%20on%20my%20computer%20and%20I'm%20having%20the%20same%20problem.%26nbsp%3B%20So%2C%20I%20do%20not%20believe%20it%20is%20specific%20to%20their%20computer.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20go%20through%20the%20process%20of%20creating%20a%20macro%20and%20saving%20to%20my%20personal%20workbook.%26nbsp%3B%20I%20exit%20Excel%20and%20go%20back%20in%20and%20create%20a%20new%20workbook.%26nbsp%3B%20When%20I%20click%20on%20Macros%2C%20I%20would%20expect%20to%20see%20a%20list%20of%20my%20macros%20in%20my%20personal%20workbook%2C%20but%20it%20does%20not%20show%20up.%26nbsp%3B%20I%20have%20to%20open%20my%20%22PERSONAL%22%20workbook%20that%20contains%20my%20macros%20to%20use%20in%20my%20other%20spreadsheet.%26nbsp%3B%20It%20didn't%20always%20work%20this%20way.%26nbsp%3B%20How%20can%20I%20configure%20so%20my%20personal%20macros%20are%20available%20whenever%20I%20open%20ANY%20workbook%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-455154%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-456041%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20see%20new%20Personal%20Macros%20in%20new%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-456041%22%20slang%3D%22en-US%22%3EPerhaps%20your%20personal%20workbook%20is%20not%20opening%20when%20you%20open%2Fcreate%20another%20workbook.%3CBR%20%2F%3E%3CBR%20%2F%3Ehere%20are%20the%20steps%20you%20need%20to%20make%20sure%20are%20done%2C%20in%20order%20for%20your%20macros%20to%20be%20visible.%3CBR%20%2F%3E%3CBR%20%2F%3E1-%20First%20place%20your%20macros%20in%20a%20file.%3CBR%20%2F%3E2-%20make%20sure%20that%20your%20Macros%20are%20not%20%22Private%20Sub%22%20%3CBR%20%2F%3E3-%20once%20you%20placed%20your%20macros%20in%20the%20file%2C%20then%20under%20the%20view%20tab%20click%20%22Hide%22%20(%20you%20do%20this%20becuase%20when%20your%20personal%20workbook%20opens%2C%20it%20does%20not%20the%20workbook%20itself)%3CBR%20%2F%3E4-%20Now%2C%20you%20need%20to%20save%20the%20workbook%20with%20the%20xlsb%20or%20xlsm%20format%20and%20place%20it%20in%20the%20following%20start%20up%20directory%20C%3A%5CUsers%5CYourUserName%5CAppData%5CRoaming%5CMicrosoft%5CExcel%5CXLSTART%3CBR%20%2F%3EReplace%20the%20YourUsername%20to%20your%20login%20account%20name.%3CBR%20%2F%3E5-%20now%20you%20are%20all%20set.%20when%20you%20open%20any%20workbook%2C%20whether%20new%20or%20an%20existing%20other%20workbook%2C%20the%20personal%20workbook%20opens%20but%20you%20will%20not%20see%20it%2C%20as%20it%20is%20hidden%2C%20but%20all%20your%20macros%20will%20be%20showing%20in%20the%20macro%20section.%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20this%20helps.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-456976%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20see%20new%20Personal%20Macros%20in%20new%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-456976%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20this%20worked.%26nbsp%3B%20The%20key%20was%20to%20check%20if%20the%20PERSONAL%20file%20already%20existed%20in%20that%20directory%20and%20move%20or%20delete%20it.%26nbsp%3B%20Then%2C%20open%20the%20macro%20file%20and%20hide%20it.%26nbsp%3B%20Then%20save%20the%20file%20to%20that%20folder.%26nbsp%3B%20It%20took%20a%20couple%20tries%20to%20get%20the%20sequence%20correct%2C%20but%20it%20then%20worked%20as%20I%20hoped.%26nbsp%3B%20This%20made%20my%20day.%26nbsp%3B%20Thanks%20again!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Paul_R1020
New Contributor

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 through the process of creating a macro and saving to my personal workbook.  I exit Excel and go back in and create a new workbook.  When I click on Macros, I would expect to see a list of my macros in my personal workbook, but it does not show up.  I have to open my "PERSONAL" workbook that contains my macros to use in my other spreadsheet.  It didn't always work this way.  How can I configure so my personal macros are available whenever I open ANY workbook?

2 Replies
Solution
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.
Highlighted

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!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies