Have you tried setting the name with VBA?

In the editor window ( ALT F11) , hit control G to open the immediate
pane and type in

ActiveSheet.Name = "MySheet"


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=552820