Event When the excel opens

T

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
 
N

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
 
H

Hemant_india

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

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
 
N

NickHK

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

NickHK
 
C

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB code to call a macro......? 4
Sharing Excel 365 Mac<->PC 0
Macro Code required..........? 3
Excel opening 1
VBA Help required...................! 4
Need Help with Macro Security 1
Drop Down Menu on the Standard Toolbar 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0

Top