Run on open macro
 

Hi there

I would like a macro to run on open in a particular workbook. I know there
is a simple visual basic line that will do this for me but it escapes me!

Does anyone know?

Thanks

Run on open macro
 

Hi

You need to place the code (or reference it from) the Workbook_Open
event in the ThisWorkbook module of the workbook concerned - navigate
to the little Excel workbook icon next to the File Menu, right-click
and go View Code. This brings up the Visual Basic Editor with the
ThisWorkbook module open. Paste your code in there with the following
name:

Private Sub Workbook_Open()

'Your code here

End Sub

I hope this helps!

Richard


JaB wrote:

Hi there

I would like a macro to run on open in a particular workbook. I know there
is a simple visual basic line that will do this for me but it escapes me!

Does anyone know?

Thanks