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.


"NickHK" wrote in message
...
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