Thanks Gord.
I have been following some of your posts on other web pages, you seem to get
everywhere...:)
I do know that they are not pages, I was only quoting what was showing in
the editor.

Bryan.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Double-click on Thisworkbook and paste the code in there.

BTW.........for clarity

Sheet1 (Front Page)
Sheet2 (Home)
Sheet3 (A)

are Worksheets, not "pages".

"pages" are what you print.


Gord Dibben MS Excel MVP

On Sat, 1 Nov 2008 18:02:01 -0000, "Bryan De-Lara"
wrote:

Gary, I have 3 pages, I've opened the basic editor and tried everything
but
I can't seem to get it to work.
I have Sheet1 (Front Page)
Sheet2 (Home)
Sheet3 (A)
And this workbook. Do I have to insert a module and put it there on click
on
one of the pages in the basic editor?

Bryan.

"Gary''s Student" wrote in
message
...
For the second question. Include the following code in the Workbook
code
area:

Private Sub Workbook_Open()
Sheets("A").Activate
n = Cells(Rows.Count, 1).End(xlUp).Row
For i = 1 To n
If Cells(i, 1).Value = Date Then
Cells(i, 1).Select
Exit Sub
End If
Next
End Sub

When the workbook is opened, sheet A will be activated and the cell in
column A containing today's date will be selected.
--
Gary''s Student - gsnu200811


"Bryan De-Lara" wrote:

1. Why can't I record a macro when I type a name in a cell, but can
when
I
use a text box? Is it possible?

2. I have a 3 page workbook. I have the opening page, then the home
page
and
then the 'A' page. On the 'A' page I have in column A the dates for
everyday, minus week ends and bank holidays from 02/01/2008 up to 2015.
I
want to be able to go directly to today's date as soon as it is opened.
There will be 6 others using this workbook, and depending on where it
is
when saved will open in that position. Not all will have it where it
needs
to be to update daily.

Any help would be greatly appreciated. Thanks.

Bryan.