Problem with Macro when saved to Personal workbook

I have the below macro to split workbooks. I cannot credit where I got it because I do not remember. It is a great macro with one exception, I have to set it up in each workbook where I want to use it. If I save it to the PERSONAL workbook so I can use it on multiple workbooks, it bombs out. I do not know VBA (although I want to learn it). Does anyone know what tweak I need to make to it in order to save it to the PERSONAL workbook and have it work whenever I want to use it?

Thank you in advance for any assistance you can provide.

Please Login or Register  to view this content.

You don't say where, or how, it bombs out. Hazard a guess ...

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

The changes in the code have nothing to do with where the code is created/saved.

Please review the forum rules regarding code tags.

Originally Posted by Leah Jonas

Okay, it didn't seem like it would but I am not that familiar with coding. So where to I find "active workbook" instead of "this workbook"? I do not see it in the box labeled project - VBAProject which is where I find "this workbook".

Please re-read post #2 and compare what is written there with your actual code as listed in post #1.

Find the first line of code. Change it to the second line of code. Save it. See if it works. I never use Personal Workbooks so I can't test it.

You're welcome.




Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.