Copy a template sheet that is hidden!

**JamesGoulding85** · 06-19-2013, 09:45 AM

Ive got a template sheet that ive hidden, im trying to copy it and assign a new name to the sheet according to what year the user types in. the problem im having is that when the tab is hidden the copy remains hidden and when I input a visible line everything goes wrong.

Help Please

Please Login or Register  to view this content.

**Norie** · 06-19-2013, 09:59 AM

Why not make the template visible, copy it and then hide it again?

**JamesGoulding85** · 06-19-2013, 10:08 AM

Ive just tried that and I think that is the right way to do it, but there must be a problem with my code as its not showing the new tab, or sometimes it does and othertimes it doesn't and it renames the master tab.

im think im getting confused with my activesheet bit.

can you spot where im going wrong?

thnaks

**Norie** · 06-19-2013, 10:54 AM

Perhaps you could try something other than ActiveSheet, or maybe do things in a slightly different order.

For example, unhide template, copy it, rename new worksheet, which should be the active sheet, and then rehide the template sheet.

Or, and this really depends what's on the template sheet, copy the contents of the template to a newly created sheet.