The workbook starts with one sheet and using other code, I prompt use
to inser a new one. At that time the user input, which is the employe
number, is entered in a cell and the sheet name is changed to the em
code also.

when users enter emp codes, I need to validate if there already a shee
with the same emp code. Then I can pop up a msg telling the user tha
that emp code already exists

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