How to run VBA macro when the workbook is open?

[Ji Wenke]

Hi
I write a Macro in VBA IDE module 1 as:

sub Selection()
xxxxxxx
end sub

If I want EXCEL to run it when this workbook is open,how
can I do that by VBA for that ?(Any sample code available?)


Thanks!

BRs
Ji

 

[Vasant Nanavati]

Hi:

Put the following macro in the ThisWorkbook code module:

Private Sub Workbook_Open()
Call Selection
End Sub

I would suggest calling the macro something other than "Selection", though.
Never use reserved words as names!

Regards,

Vasant.