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