Hiya experts!!

I have recorded!!!! (shame? naaah I have no shame!! :) )
macro that inserts new spreadsheets into the workbook and it just fail
to deliver because of the set name e.g. "Sheet2".

Could you please let me know how to make this new sheet a variable an
then via a msgBox enable the user to rename it? I guess it would b
something like that:

Sheets("VARIABLE").Name = "msgBox INPUT"

Many thanks!

--
Petitboeu
-----------------------------------------------------------------------
Petitboeuf's Profile: http://www.excelforum.com/member.php...fo&userid=1060
View this thread: http://www.excelforum.com/showthread.php?threadid=49517