Event When the excel opens

[Thyagaraj]

Dear Friends,

I need to run a set of codes when ever excel is opened and another set
of codes when ever excel is closed, is this possible..?



Thanks in Advance

Regards
Thyagaraj

 

[NickHK]

Thyagaraj,
Your Personal.xls WB is open/closed along with Excel, so any code in it's
Workbook_Open/BeforeClose events will fire.

NickHK

 

[Guest]

how to store macro in personal xls?
i only get options
1 all open worksbooks
2 this worksbook
3 book1

 

[NickHK]

Not sure what you looking at, but in the VBA IDE, View>Project Explorer,
will bring up a window, showing the worksheets/userforms/modules for all
open workbook.
Select Personal.xls, then add where necessary.

NickHK

 

[Guest]

nick
i do not see word personal anywhere
what could be wrong?

 

[NickHK]

Which version of Excel are you using ?
Search your computer for this file, "Personal.xls".

NickHK

 

[Chip Pearson]

It is quite possible that the personal.xls workbook has not yet
been created. Record a new macro, what it does is irrelevant,
and change the "Store macro in" setting to "Personal Macro
Workbook". This will create the file and then save the macro to
that file.