Object Name
 

more info. I have a workbook that has a sheet that's copied to a ne
sheet and the user gets a promt for employee number. that emp numbe
is also the sheet name.

thak

--
halem
-----------------------------------------------------------------------
halem2's Profile: http://www.excelforum.com/member.php...nfo&userid=993
View this thread: http://www.excelforum.com/showthread.php?threadid=26288