Cannot Run Macro 'OnLoad'

[Jaxspades]

Hey guys,

I'm new VBA but not to programming...yet every once in a while, I find an eror that just throws me.

I have worked through a project I'm doing for a comapny that was written by someone else and I had most of it working, but after running a short while it would throw an error -- "Cannot run macro 'OnLoad'. The macro may not be available in this workbook or all macros may be disabled."

I have macros enabled. I have looked through as much code as I can so far and have not ONCE found a macro named "OnLoad".

Google has no answer. Yahoo has no answer. MS Support has no answer (not surprising....).

Hopefully you can help me...

Thanks for anything!

[Marcol]

Check in your workbook in the VBa Workbook Module

This Workbook > Private Sub Workbook_Open()

If there is a macro, sub or function called there that cannot be found, that is what is being referred to.

Hope this helps.


If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly. In many cases, including this one, the exact error message is a good thread title.

Thanks.

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[Jaxspades]

Please Login or Register  to view this content.

No functions or subroutines, just assigning a few variables...

Maybe in Workbook_Activate()? Idk, I'm new to VBA...its a bit different than VB. And it doesn't help me at all when I didn't create this program, ahaha.


thank you for the help so far!!

[shg]

In the VBE, do Edit > Find, and search for OnLoad with Current Project ticked.

[Jaxspades]

It didn't find OnLoad in the entire project...why would excel say that if the project doesn't even reference it???

[shg]

Do you have any add-ins installed?

[Jaxspades]

FOUND IT!!!!

For your future reference...

This is custom ribbon XML. It had the problem the entire time...taht's why I couldn't find it with the vbe.

Please Login or Register  to view this content.

[esaunders]

FOUND IT!!!!

For your future reference...

This is custom ribbon XML. It had the problem the entire time...taht's why I couldn't find it with the vbe.

Please Login or Register  to view this content.

Hi. I am having the same exact problem. I tried everything listed in this string of comments, except I am having trouble with the the custom ribbon XML. I am not a programmer by any means and researched how to try the other steps. This one is stumping me though... where do I go for the XML editor? Like I said, I followed all of the other previous steps to no avail (I have no add-ins, I searched VBA, etc.). Any help is appreciated!!