View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Hemant_india[_2_] Hemant_india[_2_] is offline
external usenet poster
 
Posts: 107
Default Event When the excel opens

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