Scroll left on Workbook open

[prasadmokashi]

Hi,

I have many columns in my excel worksheet ( upto "AS" ).
When it opens up, by default it is scrolled to the rightmost column.
I want to see the first column ( A ) on my worksheet open.
i.e. scroll to the left most.

Can anybody please tell me how can I achieve this using VBA ?

Thanks,
Prasad

 

[SkipVought]

Hi,

In the Workbook Open event the following code...

Sub Workbook_Open()
  ActiveSheet.[A1].Select
End Sub

Skip,
[sub]
[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart! [/sub]