Thanks Tom... looking good..., but I got a run time error which says
"While renaming a sheet you entered an invalid name"
refers me to line :
sh1.Name = Left(sName, Len(sName) - 4)
Any ideas... ?
(Im not sure that the name of the tab has to be the same as the sheet
which it is opening - ie it can be any name or any sheet, as long as its
not the same as the first sheet..
Kind Regards
Darin
*** Sent via Developersdex
http://www.developersdex.com ***