Embedd startup module in application

Is it possible to have a startup module embedded into application, so whenever you open any file, the code would run?

Thanks,
Viktor.

Originally Posted by SOS

Hi Vikxcel,

Place your module your Personal.xls and make sure it is used as a Workbook_OnOpen module then that should do what you ask (to a degree).

Example:

I placed this code:

Please Login or Register  to view this content.

into the "This Workbook" section of my Personal.xls, colsed Excel, reopened and saw the Message Box.

But that only works the FIRST tine you open Excel. If you then open another file (in the same Excel session) that code won't run

Thanks SOS, everything makes sense, but i can't find this personal.xls you're talking about.

Originally Posted by Vikxcel

Thanks SOS, everything makes sense, but i can't find this personal.xls you're talking about.

nevermind, i got it, you're supposed to make a personal.xls file and drop it in the xlstart folder. Thanks Sos.