ActiveSheet.Range("B3").Select

[Pinaceous]

Hi All,

I thought I had this and it slipped away from me, so help!


I have a Workbook where I have 16 Sheet, ie up to Sheet16.

How or where do I put

ActiveSheet.Range("B3").Select

?

Thanks,
Pinaceous

 

[shg]

Put is where for what?

 

[Pinaceous]

Hi,

I wanted to put this in "ThisWorkbook", so then every sheet that I open goes to Cell B3.

Thanks you!
Paul

 

[shg]

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
  Sh.Range("B3").Select
End Sub

 

[Pinaceous]

Thank you shg!

That did it!

 

[shg]

You're welcome.