Where Is The Personal Macro Workbook Stored and How to View It (Part 2 of 4)

[@excelisfun]

Thanks for this awesome 4 part series!!!

[@adeoyeoyebade]

While i'm a novice to excel macros, your lessons have been very helpful. I now copy and paste my research results with just keyboard shortcuts assigned to excel macros. Gracias!

[@xNoScOpErZx]

Very informative thanks for providing this for free of charge

[@dustinkurtz9939]

Saved my butt today. I opened it to add a macro, then made a mistake and just closed it without hiding it and couldn't find it again. Found it using this video. Thanks!

[@adrianborinsky2989]

Thank you, it made it so easy to transfer my macros from my work computer to my home computer !

[@kellyboyd295]

Thank you! This is another great video! Super helpful!

[@ExcelCampus]

Glad it was helpful! 😀

[@AWSService-2]

Thankyou sir your videos are very valuable

[@JefferyHixon]

I read 5 pages of MS documentation and this is way better. Thanks!

[@sandraellis5561]

I am just a novice, but your videos are EXCELLENT. Thanks so much for taking the time to do this!

[@frankaquino10]

I learn a lot from your tutorials John. Thank you for sharing your knowledge. I use simple macros and make a lot of mistakes as well. Consequently I have dozens of useless macros stored with no way (that I know of) to delete multiple bad macros. Is there a way to select and delete lots of (or even all) macros? Thanks and regards.

[@keuaychanthangone7333]

Thanks for sharing these useful and helpful videos

[@johnmccormick2883]

Thanks for the help Jon! I have macros in dozens of my excel files… would like to know how to collect them into a new personal macro workbook. Cheers 🍺🍺

[@wenj1289]

Thanks! It's really helpful to know about the immediate window.

[@theadamcarr]

Hi Jon, I'm thinking about moving the location of XLSTART to OneDrive. I'm asking because my IT department recently re-imaged my laptop, and I lost hundreds of macros. Unfortunately, they don't allow backing up hard drives to OneDrive. Basically, I would like to automatically back up my macros without having to do it manually. I would appreciate any ideas you may have. Thanks!

[@64mustangfan]

Excel Campus, you guys are my Excel mind readers, haha! Three issues swatted from your KZbin page the same day, thanks, I'd better subscribe :-)b

[@ExcelCampus]

Great to hear that! 😊

[@anjinoureddine1513]

thank you very much, that was like a nightmare for me, every time two personal files opening

[@teoxengineer]

Also, we can find this folder path by using below without VBA: File>Options>Trust Center>Trust Center Options>Trusted Paths>Change (we can copy this path easily and paste File Explorer Window) Thank you so much

[@dangelorrrr]

Hello Jon! Enjoying this series. Would you explain the personal workbook xlsb extension?

[@invalidname1667]

Thanks buddy, Your hide option saved my day. Thanks

[@kims144]

Hi Jon, Thank you for these wonderful videos. I have learned so much from your videos and put it into practice. Thank You! Look forward to diving more into the Macros and VBA stuff.

[@YlmazDALKIRANscallion]

thx for clear instruction greetings from turkiye

[@girishtax]

Usefull vidio in 2022, thank you

[@user-gd2bd7gh5o]

Thank you so much! great video

[@ExcelCampus]

You're welcome, • ! :)

[@marcoperrotta9619]

Hi Jon. Thank you for this video. I have a question: does Excel give the user the opportunity to have more than one personal macros workbook? Thank you, bye, Marco

[@MrDevTeam]

hello thank you for your good videos on your channel but just i am asking after finishing all your videos and study them well this means that i will be an advanced excel freelancer or should i need more features to start working on some thing like freelancer.com and fiverr.com etc

[@tristanquintus3200]

Thanks Jon, this is a useful video. I could have used this info sometime ago when I was struggling to view this personal file and to also locate it. I do like the method you suggested using to obtain this personal file path.

[@winnerspeed]

Awesome, thank you

[@autobotsNdecepticons]

Maybe paste the path into the description for quick reference...

[@jackcurl2005]

So, the Roaming directory as you show it is correct, at least as far as Windows 10 goes. If only Microsoft could have the correct link specified on it's personal.xlsb location page. It uses Local instead of Roaming. I wonder if the different locations are based on how the product is installed-standalone Office/Excel 20xx vs perpetual 365. Even if true, their documentation needs to reflect that. [The only reason this even came up is that I needed to get rid of the ~ lock file because it kept asking me if I wanted to save changes to PERSONAL.XLSB. I made changes months ago and successfully saved and used for a while, but after a crash is when this started happening. (It's amazing the stupid things which might cause Excel to just crash close with no warning, such as arrow down or switching tabs)]

[@Pankaj-Verma-]

Thank you very much for your kind help!

[@emmaren2163]

Hi Jon, thanks for the tutorial. Just a quick question. When I copy the path to AppData, I can not find the excel workbook in XLSTART. Can you help me? Thanks.

[@financnifitness2583]

Why ccannot I see the "PERSONAL.xlsb" as you have it? I ust do not have anthing there called like this :/

[@crystalmendoza8140]

Is there any benefit to having the personal macro workbook hidden? or is it just a personal choice? I came across an issue where my personal macros became frozen and I'm not sure why and I don't know if hiding it would have helped in preventing that issue

[@YHDPM]

So you can run code from your personal macro workbook on any other active workbook as long as the personal macro workbook is open in the background?

[@nigelmoreira5940]

After clicking on the Macros option in the developer tab, naming my macro then I am unable to see an option to save my macro in the personal macro workbook. Are there some steps prior to this?

[@frankaquino10]

Actually, while I'm here: I have 30 columns of numbers, each of which I want to display in a line chart one at a time. So one chart only, I select the data, observe the chart then I use the mouse to move the blue box enclosing the data to the next column and observe that. Doing it 30 times is a strain on my mouse hand. Is it possible to use the keyboard instead?

[@rencemc]

Question: I added 3 modules to my Personal.xlsb file (FlagIncorrects, ClearCells & WriteToSheet). However, when I go to add the modules to the ribbon, I only see ClearCells. Do you have an idea why?

[@nikitagriffin3904]

John great video I am having a bit of a issue, I created the personal macro workbook and it runs fine but when I open up a new excel spreadsheet it does not run. please help.

[@wants2knowy159]

Thanks for this. Very well done, very helpful.

[@controlsgirl]

great video

[@ExcelCampus]

Thanks for the visit 😀

[@BigTymer0007]

Amazing thank you!

[@ExcelCampus]

Thanks Ian! :-)

[@bhawendrakumar3168]

Thanks

[@wujizhang]

Hi Jon, I have recorded a macro and saved it in the personal workbook. I found its path using the ?thisworkbook.Path function, however, when I open files using the selected path, I don't see anything at all inside that folder... What should I do?

[@wujizhang]

What should I do now? Did I miss some important part? (eg. disable/enable some function?)

[@alexandradirani8341]

Hi Jon! I don't seem to have this XLstart folder on my laptop, hence I don't have the option of selecting the Personal Macro Workbook file - any ideas of how to enable it? Thanks, Alexandra

[@shubhamcena4576]

I have one query regarding is VBA when i put this macro file on server for use more user , then other user pc not run this macro file . Then what i do...plz give me solution

[@RahulGupta-vv6ui]

HI Jon.. Your excel video's are great to watch and it's very helpful !! I have been following for very long time. Want to Understand 1 thing from you... Can anyone else have access of my Personal Macro Workbook??, The reason is that, I have created few macros for myself for my office related work, using same macros for various different excel file, once work get's completed on that excel file, I have to save file on Share drive, it is being access many of my colleague . I mean anyone can open that excel file saved on share drive, and can go to VBE editor, can have access of my personal macros codes used for in that Particular file. Please share your view on this. Thanks!!!

[@christophernolan8761]

Can a personal macro workbook be stored to One Drive?

[@StephenBeale]

Thanks!

[@smith28c]

Hi Thank you for this excellent demonstration. I am using Excel 2011 for Mac and after trying this out and reopening Excel, I am getting Message Locked file name: Personal Macro Workbook (Read-Only) after selecting (Cancel) it shows location to edit to the file but I can't seem to find the file any help to solve this. regards. Don

[@smith28c]

I managed to locate the XLSB file deleted and did macro again but I steel get message: Locked file Cancel or Read-Only buttons, any idea what could be wrong?

[@mehmetdogu384]

i will follow you you are good.

[@ExcelCampus]

Thank you! 😀

[@denkialetshabo]

Can u access Personal Macros without the developers tab? I dont have that tab in excel 2016.

[@gf3011]

You have to add the tab to your ribbon, it’s hidden for some reason! I found out it existed but thought I didn’t have it either because I have 2010, heard all Excel does, and found it: -Click on your file tab -Options -Customize ribbon -On the right box titled Main Tabs, see Developer, click on it to get check mark -Below it, click New Group -Click OK

[@ariellavy]

i liked it thanks ariel

[@mehmetdogu384]

I lost PERSONAL MACRO WORKBOOK in my pc, it is not in xlstart folder , it is not disabled. i am trying different ways but so far no success.

[@donaldreeves2782]

I can't find my PWB. It used to be there and shown in VBA, but it doesn't any more. I tried to create another one, but get a message saying that the PWB must be open in the start up folder to be able to save the small macro I was using to create the PwB. I had several macros in the PWB before it disappeared and had to re-write most of them in a regular workbook which I placed in the startup folder. I can use the macros, but the workbook is always visible. Will trying to hide it as you have shown actually hide it so it won't be visible. (I'd like to be able to create another PWB, tho).

[@ExcelCampus]

+Donald Reeves Hi Donald, Great question! The PMW might have become disabled at some point. You can check by going to the File > Excel Options > Add-ins and choose Disable Items from the Manage drop-down. If you see it listed there you can re-enable it. You might also search your computer for "Personal.xls" to see if the file is somewhere else. Otherwise, you should be able to create a Personal.xlsb file and put it in the XL Start folder. That should restore the issue and you should be able to record to it. You can also use the code the following code to find the XLSTART folder: ?Application.StartupPath I have read about others having this issue, but have not yet experienced it myself. Hiding the window will hide the file on startup. After you hide it, you will be prompted to save it when you close Excel the first time. Say Yes, and that will keep it hidden on the next startup. I hope that helps. Let me know if you are able to get the original back or record to the PMW. Thanks!

[@donaldreeves2782]

+Excel Campus - Jon I will try these suggestions. It's my computer at work that I'm having this problem with, so I wont be able to try until Monday. Thank you for the help. Will let you know how it turns out.

[@ExcelCampus]

+Donald Reeves Sounds good. Have a nice weekend!

[@rajivkukreja]

what if personal workbook is missing in excel?

[@ExcelCampus]

Check out video #1 on how to create the personal macro workbook. kzbin.info/www/bejne/qHWVXqCJl7mogpI

[@dguise0]

Interesting

[@mulieven]

You can find quickly where is the XLSTART folder using the Immediate window, without first selecting the Personal Workbook in the Project Window, and even without having a Personal macro Workbook, using ? application.StartupPath in the Immediate window.

[@ExcelCampus]

Thanks Muli! There is an annotation with that line of code in the video. You might not have been able to see it depending on what device you are watching the video on. It is a faster method as long as the Personal Macro Workbook is stored in the default XLSTART folder. Sometimes the computer can have multiple XLSTART folders if you have multiple versions of Excel installed on the same machine. That's probably rare, but I have a machine with all versions from 2003 on installed on it. Anyways, thanks again for your comment! :-)

[@StephenBeale]

To copy and paste into VBA: ?thisworkbook.Path To copy and paste into a window try this: C:\Users\[INSERT USERNAME HERE]\AppData\Roaming\Microsoft\Excel

[@sukitroongapinun573]

Nice video, but make sure viewers really wants personal macro workbook. If you don't, don't create the personal workbook. Many will end up an exhaustive mess in finding the way to delete the personal macro workbook.

[@sukitroongapinun573]

For those suffering from the uncontrollable personal macro workbook, search --> Solve the "File in Use" error. It is a page by Microsoft itself, follow it. Next, locate the personal workbook in XLTR folder, then delete the personal workbook xlsb file. It will take much time to eliminate it. Best wishes.