I don't believe you can do that, but I've been proved wrong before. Try this:
http://www.mcgimpsey.com/excel/event...efromcell.html

You may get it to work with some modifications but I don't think it is going
to work with dates...


Regards,
Ryan--

--
RyGuy


"Veronica" wrote:

Good morning.

I have been trying to put a macro in place that will rename Sheet 1 tab to
the current date, every day, in many different new workbooks created daily.
I know the function =TODAY() however I can't seem to get that function to
take on the tab itself. I see that you can Insert an Excel Macro on the tab,
but I don't know how to create this either. I can get the Tab to read Macro1
- but then I don't know how to write that Macro.

I appreciate any input!
--
Thanks! Veronica.