Can I get different sheets to open on different cells?

[jedibrown]

I was just wondering if it was possible to open different sheets on different cells?

For Example, I want sheet 1 to open at A1 but I want sheet 2 to open at B5.

This is because the majority of cells are locked on some sheets so I want it to open on an unlocked cell.

I am using Excel 2010 and have command buttons linking each sheet.

Any help would be appreciated.

Thanks

 

[Trevor G]

When you select the sheet tab use the right mouse button and the from the drop down you can select worksheet then next drop down select Activate and add this code, jsut do this for each sheet if you want to activate different cells.

<font face=Courier New><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Worksheet_Activate()<br>Range("B5").Activate<br><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[Drinkysr]

A simple VBA event handler procedure should do it:
Private Sub Worksheet_Activate()
Range("c1").Activate
End Sub

You can put this in the VBA code for the worksheet you want to open on cell C1.

Put another with Range("B5") (or whatever cell you want substitued for B5) in the VBA code for the next worksheet and so on.

 

[jedibrown]

Perfect works perfectly.

Thanks both for your help!