select specific sheet and cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yendorian - 09 Nov 2007 16:37 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 09 Nov 2007 20:59 GMT

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.

Signature

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

>I have an Excel workbook which has 5 worksheets. I would like to add some
>VBA
[quoted text clipped - 4 lines]
> 5 or This Workbook?
> Can anyone help please

Reply to this Message

JLGWhiz - 09 Nov 2007 21:32 GMT

Put in the ThisWorkbook code module.

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

> 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
[quoted text clipped - 8 lines]
> > 5 or This Workbook?
> > Can anyone help please

Reply to this Message

Yendorian - 14 Nov 2007 09:29 GMT

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

> Put in the ThisWorkbook code module.
>
[quoted text clipped - 15 lines]
> > > 5 or This Workbook?
> > > Can anyone help please

Reply to this Message

Yendorian - 14 Nov 2007 09:28 GMT

Sorry about that. Problem now solved. Thanks

Reply to this Message