SOLVED

How do I call an Excel VBA PERSONAL procedure from a subroutine of another project?

Copper Contributor

I have a macro that runs via a click on a control button on an Excel worksheet. This macro needs to run a subroutine that is in the XLSTART/Personal.xlsb - (this macro is stable for years and working well via a click on a custom button I've put on the Ribbon).

Now I want to run it from another macro - should be simple enough to write:

                                    Call Re_Set            - there is 1 optional argument that I don't need,

but it just says Sub or Function not defined.


How do I get it to recognise a Personal routine?


[Sorry if this isn't strictly what should be asked here or the Subject isn't phrased well, but you wouldn't believe the time I've spent and the rubbish links I've been given searching 365 documentation etc. with goodness knows how many versions of the subject]

 

Good grief - I HAVE corrected the highlighted errors, now there are NO highlighted errors.  -  And of course I've submitted more than 2 msgs within 300 seconds - this same msg. after editing!!

 

Now it says use the Save button - there is no Save button!!!

 

3 Replies
best response confirmed by Phil157 (Copper Contributor)
Solution

@Phil157 

Try

    Application.Run "PERSONAL.XLSB!Re_Set"
Worked like a charm - thank you very much.

While I've got you here... For the last few years, since using Office 365, I've never had the Help work in Excel. - For all the options except "Feedback" the black window on the right always says "Sorry, something went wrong. Please check your network connection and try again."
Any idea where to complain to, I've submitted feedback and 2 or 3 other queries, but received no reply.

Thanks again, Happy Christmas, Phil.

@Phil157 

I'm afraid I cannot help you with that. Sorry!

 

Happy Holidays!

1 best response

Accepted Solutions
best response confirmed by Phil157 (Copper Contributor)