Hi,

I've an Excel Spreadsheet (Report) with n worksheets.
I'd like to create a VBA macro that, when I open the Spreadsheed:
a) asks if I want to add a new worksheet. If the answer is yes, then:
b) prompts a form to input the worksheet name
c) creates a new worksheet using the name inputed and positions the
worksheet as last
d) assigns a template (T_Z) to the worksheet

Alternatively steps c) and d) might be as well:

c) copies an existing worksheet Template_Z, renames it using the name
inputed and moves it to last place

Is this doable?

Thanks a lot!

G