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

NickHK

"Hemant_india" wrote in message
...
nick
i do not see word personal anywhere
what could be wrong?
--
hemu


"NickHK" wrote:

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

NickHK

"Hemant_india" wrote in message
...
how to store macro in personal xls?
i only get options
1 all open worksbooks
2 this worksbook
3 book1
--
hemu


"NickHK" wrote:

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

NickHK

"Thyagaraj" wrote in message
oups.com...
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