Personal.xls run a test on opening other sheets

I want an ON_OPEN macro to run, not from code embedded in 'this workbook' but from personal.xls. Is this possible?
Who is Participating?
[ fanpages ]Connect With a Mentor IT Services ConsultantCommented:

To expand on matthewspatrick's response, save the attached Add-in file in an XLSTART folder.


Patrick MatthewsCommented:
Yes, but please be more specific.  Are you saying, "whenever I open *any* file in Excel, run a macro from my Personal.xls"?
GrizzlerAuthor Commented:
When I open any workbook, I want a macro to fire. The sub will run tests against active workbook and prompt user accordingly. Want to trigger both from file open or double click to open from folder.
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

GrizzlerAuthor Commented:
short answer "YES"
GrizzlerAuthor Commented:
current target excel2003
GrizzlerAuthor Commented:
Perfect! Thanks....
[ fanpages ]IT Services ConsultantCommented:
You're welcome :)
GrizzlerAuthor Commented:
So, if I might trouble you a bit further.... Looking for design strategy best practices....

In the past, I coded single purpose workbooks that contained code in embedded modules.
Works fine for "enter data, do stuff vba, output data", on locked sheet where the user doesn't alter the sheet structure.

Recently I started using Personal.XLS to add global functionality for Excel.

On another on going project, I have some legacy (system not by me) sheets that use internal and external links to get data and cross populate. The sheets are unlocked and edited freely by novices and people of some skill, alike. As you can imagine, the sheets are a mess. Too many issues to list....

One of my goals is to remove all the link formulas and replace them with a codebase that gets and places data and fixes errors. This is part of a project to migrate to an actual database soure, rather than Index/Match or Vlookup. The scale at which we have applied these methods is nearing critical mass and the fragile nature of what we are doing is becoming more and more evident to the people who can facilitate change.

I am going to remove as much code as possible from workbooks and make it built in....

Any way the simple generic question....

Advantages using XLA vs Personal.XLS?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.