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.