excel programming problem: create a new sheet

[AJ_UK]

Hey guys.
I'm doing an I.C.T. Project for A-level.
Its an excel project (crap, i know! Would have been much better if it was a vb project).

Anyways, i gotta do it, so heres my problem:

Its a 'Budget Wizard'. i.e. you enter a few figures, and it calculates a budget for you.

I've created a custom toolbar, which is created when the workbook loads (Auto_Open macro).
On the toolbar, it has a save button. But as the workbook is protected, and is not designed to be saved, i need to select the area of stuff they will want to save, copy it, and paste it in a new spreadsheet, and then save that as whatever they want!
Pretty tricky for a novice like me..!

I'd be really grateful if any of you guys could help.
THanks,
AJ

[xhomerx]

Workbooks.Add

[AJ_UK]

xhomerx,
thats cool, but i don't know how to use that!

-AJ

[xhomerx]

Maybe I am missing something, That line of code will add a new workbook. After the workbook is created you use it like any other workbook - You can dump all your information into it and allow the user to save it or do whatever they want with it.