copy worksheet that is hidden and rename it using a userfom

Here
http://www.excelforum.com/excel-prog...a-userfom.html
I asked for a macro that copy an worksheet and rename it using a userfom!
I received the xls file attached to this mail !
In this xls when I click "Click me to copy s0 sheet and rename it" from final sheet, a userform appear, I type a name there and when I press ok I will have a copy of worksheet "s0" with the name typed in the userform.
If I click on "Click me to copy s0 sheet and rename it" I can create as many copies as I need.

But if I hide worksheet "s0" (using Format /Sheet/Hide) the macro will not work.
I modified the code from module 1 adding the red code:

Please Login or Register  to view this content.

But using this code I can create only a copy of worksheet "s0" (worksheet "s0" is hidden, the new sheet is visible) .
If I click on "Click me to copy s0 sheet and rename it" one more time I will have an error!
Please help me to modify the code so I can create as many copy as I need for worksheet "s0" (I need sheet s0 to be hidden but the new sheets to be visible).

You need to unhide the So sheet before creating the copy

But I need worksheet s0 to be hidden!
It's not possible ?

You unhide it, copy it& then re-hide it.

That's not the code that I added! My code is in the userform where it should be. See

Please Login or Register  to view this content.

The only thing that I would add is a check to see if the name exists, add this to a Standard Module

Please Login or Register  to view this content.

Amend the button code with this

Please Login or Register  to view this content.