Well, for me the tab names changed. Are you sure the format in your cell
is correct for a tab name?

If the new date is being used already as a tab name, the code will fail
to rename a sheet with the same name.

What happens when you comment out the "On Error Resume Next" line?

Are you sure the In article
.com,
"reaa" wrote:

JE, thanks for the reply. your code has the same effect as Gord... it
allowed the dates on each of the sheets to be calculated on open, but
now i was hoping to get teh code for each sheet to be named after
these newly calculated dates (on open). it appeared that the tab
names on the workbook remained as the old dates and were not changed
to the newly calculated date. any help you can provide would be
greatly appreciated. thanks :o)