Seelcting specific sheet and cell on startup
Thanks very much for this! It works - of course!
"Gary''s Student" wrote:
In the workbook code area:
Private Sub Workbook_Open()
Sheets("Sheet3").Activate
Range("F3").Select
End Sub
--
Gary''s Student - gsnu200755
"Yendorian" wrote:
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
|