Why don't you check that data has been entered before incrementing t
the next tab. That way you still have all the controls, etc. from th
tab that the user hasn't entered all the data for

--
bhofset
-----------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...fo&userid=1880
View this thread: http://www.excelforum.com/showthread.php?threadid=39035