Auto Tab Naming

**Gerard_Sanchez** · 12-01-2009, 10:42 PM

Can anyone help me to make the auto naming code displayed on the worksheet tab die after first entry into, so that regardless whether any values are changed in the worksheet--a minute, hour, day after-- the "namedate" stays the same.

Any help would be greatly appreciated.

Please Login or Register  to view this content.

**Kristal_Miller** · 12-01-2009, 10:51 PM

Hope my approach doesn't sound too simplistic (I'm not that experienced), but

Why not give the worksheet an original name, i.e., "Unnamed". Then before applying a name use an if statement to confirm it is still named "Unnamed" before renaming with the time stamp?

**Gerard_Sanchez** · 12-01-2009, 10:57 PM

Originally Posted by Kristal_Miller

Hope my approach doesn't sound too simplistic (I'm not that experienced), but

Why not give the worksheet an original name, i.e., "Unnamed". Then before applying a name use an if statement to confirm it is still named "Unnamed" before renaming with the time stamp?

Hi Kristal,

Wow! That was quick. I wil try to work it out. Sounds like a workable solution.

-Gerard