select specific sheet and cell
Put in the ThisWorkbook code module.
Private Sub Workbook_Open()
Worksheets("Sheet3").Activate
Range("F6").Activate
End Sub
"Doug Robbins - Word MVP" wrote:
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" wrote in message
...
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
|