Ok, your humor is interesting, but I don't see how it is helpful at this
point ..........


"Mike" wrote in message
...
White out over sheet1 tab let dry then with sharpie put 6/1/07
should work
for more sheets repeat steps

"Kelvin Beaton" wrote:

I'm not typing the date into the field.

I enter one date on the first spreadsheet and the rest of the sheets
calculate off that. so an after update event wouldn't like fire if I
don't
make the change on that sheet.
Also, I don't if this matters, but the sheets are locked for the most
part.
the cell with the date in it is one that is locked, since it's calcualted
there's no reason for the user to type there...

Kelvin




"Kelvin Beaton" <kelvin at mccsa dot com wrote in message
...
Thanks
Here's what I'm using. I have this pasted in the Code for the tab and
if I
run it manually it works, what do I need to do to make this code fire?

What I'm doing is, I use this Excel file as a timesheet. the value in
cell
D5 is the date the timesheet is to be handed in...
So for each pay period I have a Tab and I want the TAB to be the
sheet\D5
value to show.
I really only need this to update once a year... as the first day of
the
pay period changed each year...

I guess my question is, how do I fire this off for each page?
If I have this code in there, will I then always be prompted to "Enable
Marcos"?

Thanks

Private Sub Worksheet_Calculate()
Const sCELLADDRESS As String = "D5" 'Change to suit
On Error Resume Next
Me.Name = Format(Range(sCELLADDRESS).Value, "m-d-yy")
On Error GoTo 0
End Sub


"JE McGimpsey" wrote in message
...
Using my suggested solution, instead of

Me.Name = Range(sCELLADDRESS).Text

you could use

Me.Name = Format(Range(sCELLADDRESS).Value, "m-d-yy")

or some other format. Note that you can't use slashes in tab names.



In article ,
"Kelvin Beaton" <kelvin at mccsa dot com wrote:

Oh, and I like the date in the TAB to be formatted, like 6/4/07.

Thanks

Kelvin


"Kelvin Beaton" <kelvin at mccsa dot com wrote in message
...
I have a spreadsheet that has a calculated date field in "=H34+3"

I would love for the TAB to equal that value.

I think I've tried to figure this out a long time back, but I think
I
got
stuck becasue it is a calculated fileld.

Anyone know if this can be done, and how?

Thanks

Kelvin