how to auto run the macro

[macro prob]

hi all
how to run the macro automatically when i start the worksheet instead of via tools/macro/macros to run
pls help

 

[Gord Dibben]

With Excel and workbook Window maximized, right-click on the Excel logo just
left of "File" on menu bar and select "View Code".

This opens the Thisworkbook module of your workbook.

Click on the left-side dialog box(should say "General") change to "Workbook"
and select.

You will get a couple of lines of code entered automatically.

Private Sub Workbook_Open()

End Sub

Between the two lines enter your code or a call to a macro you want to run.

Gord Dibben Excel MVP