Running macro at startup
 

Brian

Go to VB Editor with your workbook open. Right Click on This Workbook and
then View Code.

Paste the code in here after Private Sub Workbook_Open() and remove any
reference to Private Sub CommandButton1_Click().

The code will run whenever that workbook is opened.

HTH.

Jim



"Brian McGuire" wrote in message
...
Hi,

I have a macro that sorts through data that I have in a spreadsheet. As it
stands now, the macro is run by pressing a command button. I would like the
sort to occur automatically every time the workbook is opened. I dont want
the macro to run at the startup of every workbook, just the workbook with
the data in it. The code as it stands now is:

Private Sub CommandButton1_Click()
'Module Sorting Macro
'1/17/04

Range("C2").Select
Range("A1:P108").Sort Key1:=Range("C2"), Order1:=xlAscending, Header:=
_
xlGuess, OrderCustom:=1, MatchCase:=False,
Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End Sub

Where would I have to put this or how do I need to alter the code to make
this sort exceute everytime the workbook opens. Any help is greatly
appreciated. Thanks.

Brian