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)