set cursor to cell position when sheet activated

[hocs]

I would like as how to set cursor to point at certain cell position, say E11, whenever the worksheet is activated.

Thanks!

 

[Jobowo]

Hi

Put this code in the code section for the sheet you want this to work on (not in a module).

Public Sub worksheet_activate()
    ActiveSheet.Range("E11").Select
End Sub

 

[hocs]

Thanks jobowo!