select specific sheet and cell

[Yendorian]

I have an Excel workbook which has 5 worksheets. I would like to add some VBA
code so that whenever the workbook is opened, we automatically go to Sheet 3,
Cell F6. And in which category should I write this code - Sheet1, 2, 3, 4, or
5 or This Workbook?
Can anyone help please

 

[Doug Robbins - Word MVP]

You will be more likely to receive a response to this if you ask in the
microsoft.public.excel.programming newsgroup to which I have cross posted
this response.



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[JLGWhiz]

Put in the ThisWorkbook code module.

Private Sub Workbook_Open()
Worksheets("Sheet3").Activate
Range("F6").Activate
End Sub

 

[Yendorian]

Sorry about that. Problem now solved. Thanks

You will be more likely to receive a response to this if you ask in the
microsoft.public.excel.programming newsgroup to which I have cross posted
this response.



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Yendorian]

Thanks very much for this. It's easy when you know how!!