-
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,
thats cool, but i don't know how to use that!
-AJ
-
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.
