Help With Sheet Addition Code (99% Solved)

[Building]

Hello,

I've gotten a lot of help already on this code but I'm in need of one last part before I think it's where it needs to be.

Please Login or Register  to view this content.

It performs as it should, copying the "Template" sheet and creating a new sheet based on the input from the message box. The last thing that I'm having issues with is that it won't copy the "Template" when the sheet is hidden. It seems to perform an operation on the sheet prior to the new sheet and I don't know what I can do to have it work as it should with the "Template" sheet hidden.

Does anyone have any ideas?

[Speshul]

I would simply use the VBA to unhide the template sheet at the start, and hide again at the end. Hidden sheets can't be accessed by VBA as far as I know

[Building]

Worked perfectly, I just had it unhide the sheet at the beginning of the code and then hide at the end- thank you.