How to run VBA macro when the workbook is open?

  • Thread starter Thread starter Ji Wenke
  • Start date Start date
J

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
 
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.
 
Back
Top