Seelcting specific sheet and cell on startup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yendorian - 09 Nov 2007 16:43 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

Gary''s Student - 09 Nov 2007 16:48 GMT

In the workbook code area:

Private Sub Workbook_Open()
Sheets("Sheet3").Activate
Range("F3").Select
End Sub

Signature

Gary''s Student - gsnu200755

> 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

Kevin B - 09 Nov 2007 16:51 GMT

Press Alt+F11 and insert the following code to the Workbook's Open event:

Private Sub Workbook_Open()

Sheets(3).Activate
Range("F6").Select

End Sub

Signature

Kevin Backmann

> In the workbook code area:
>
[quoted text clipped - 8 lines]
> > 5 or This Workbook?
> > Can anyone help please

Reply to this Message

Yendorian - 14 Nov 2007 09:31 GMT

Thanks very much for this; That's a great help.

> Press Alt+F11 and insert the following code to the Workbook's Open event:
>
[quoted text clipped - 17 lines]
> > > 5 or This Workbook?
> > > Can anyone help please

Reply to this Message

Yendorian - 14 Nov 2007 09:30 GMT

Thanks very much for this! It works - of course!

> In the workbook code area:
>
[quoted text clipped - 8 lines]
> > 5 or This Workbook?
> > Can anyone help please

Reply to this Message