Use Your Macros in Any Excel Workbook - Personal Workbook in Excel - Excel Quickie 38

[@thesheetsguy4478]

I love the personal macro workbook! I've created a new tab on the ribbon for the personal macros so they are easily accessible.

[@remikid7]

It is really helpful. I tried it in Excel 2007 and it works. Thanks a lot. It save the day.👍

[@1rdwn]

finally someone showed this properly!

[@osvaldoolguin1631]

Hi, thanks for the explanation. I've got a question. I did create a personal workbook for my macros, but the personal.xlb file is not created even though I did everything this video shows. Could this be 'cause I'm using an enterprise computer and I don't have admin privileges? Thanks in advice.

[@brianamiller4990]

I understand this will work locally across different spreadsheets, but will the macro still be available to other users if a workbook is shared or forwarded to someone else?

[@DebbieCovey-tt1kn]

getting error Personal Macro Workbook in the startup folder must stay open for recording

[@farooqnazir5455]

I created a macro and I want to use it in my workbook , but it is not working for me

[@N_Fortune]

Nice video but just an FYI... @ 4:07 to view "AppData" ...you may need to check "Hidden items" (Open File Explorer>View Tab>Hidden items) in order to see this folder.

[@TeachExcel]

Thanks for this note!

[@socialzebra8526]

Thanks for this amazing video!

[@NguyenTam-se6ot]

Awesome Video man, thank alot

[@nafiurpial7209]

That's a great video, very very helpful. Thank you a lot!

[@amoghshilpi]

if you close all the excels which are opened and try to run this macro,it will not be available. You are saying you are opening brand new excel in the video but you are really opening already minimized excel Book1 and running your macro there, which will work obviously.

[@hidingindanielsroom7268]

Hi! I like your videos, thanks for them. I'd be happy to see a series about macro in power point, eg. how to feed chart data from excel or from ppt table itself.

[@TeachExcel]

Thats an interesting topic that might be a bit too specific for me to make a series or course on, but keep bugging me about it and I will eventually try to make something on it. Currently, I'm working on finishing a Macro course for beginners.

[@afsar0066]

Thanks that's what I want 👍👍👍

[@wayneedmondson1065]

Thanks for the tip. Thumbs up!

[@TeachExcel]

Cheers)

[@mangobrother]

Thank you. Very helpful.

[@TeachExcel]

You're very welcome)

[@fredyrivera2164]

Duuuuuuuude! Thank youuu!!! :D

[@vukvolkov]

Great stuff. Thanks a lot.

[@TeachExcel]

You're welcome! Glad you like it)

[@scorpionrrr5165]

Thanks

[@TeachExcel]

You are very welcome Mr. Scorpion! :)

[@kbrax7966]

this did not work

[@dgro]

it does though

[@sassouusasoo3607]

It doesn't!

[@wilfriedvanhees]

to find the location of the personal workbook. Select the personal workbook in the vba window and paste "?thisworkbook.Path" in the immediate window