Is it possible to have a startup module embedded into application, so whenever you open any file, the code would run?
Thanks,
Viktor.
Is it possible to have a startup module embedded into application, so whenever you open any file, the code would run?
Thanks,
Viktor.
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:
into the "This Workbook" section of my Personal.xls, colsed Excel, reopened and saw the Message Box.Please Login or Register to view this content.
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
Last edited by SOS; 06-10-2008 at 02:44 PM.
Hope this helps
Seamus
Thanks SOS, everything makes sense, but i can't find this personal.xls you're talking about.Originally Posted by SOS
nevermind, i got it, you're supposed to make a personal.xls file and drop it in the xlstart folder. Thanks Sos.Originally Posted by Vikxcel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks