Automatically sorting a list

Hi

I was wondering if there was any way to have a spreadsheet automatically organised by a column when the spreadsheet is opened

Very picky i know

thanks in advance

Record a macro while doing this and then put the macro in a workbook open
event

Private Sub Workbook_Open()
'your code goes here
End Sub


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"fenlon" <[email protected]> wrote in
message news:[email protected]...
>
> Hi
>
> I was wondering if there was any way to have a spreadsheet
> automatically organised by a column when the spreadsheet is opened
>
> Very picky i know
>
> thanks in advance
>
>
> --
> fenlon
> ------------------------------------------------------------------------
> fenlon's Profile:
> http://www.excelforum.com/member.php...o&userid=32998
> View this thread: http://www.excelforum.com/showthread...hreadid=528229
>