A new form macro

[rocky 123]

Hi there,

Quite an easy one I think/hope!

I have been making a system for entering in invoices. I created a
interface which I would like to be kept the same for every invoic
entered. I want a macro that brings in a new worksheet when the custo
button is clicked, and then this new worksheet would have the exac
same interface as the other, but just the input fields be blank.

My macro so far brings up a new worksheet and goes to it, but I a
having serious trouble in getting the look of the newly inserted pag
exactly the same as the original.

Can somebody please help me out here!
Many thanks, rocky.

 

[Gord Dibben]

Rocky

Open a New workbook. Copy the formatted blank invoice sheet into that
workbook.

Delete all but that formatted sheet.

File>Save As>File Type>Template(*.xlt). Name it SHEET(Excel looks after the
..xlt extension)

Save it to your XLSTART folder.

When your invoice workbook macro calls for a new worksheet to be inserted,
SHEET.xlt will be used as the default worksheet.

In addition, to create new workbooks(not worksheets) save and name the
Template BOOK and new workbooks will be based upon this BOOK.xlt

Gord Dibben Excel MVP

 

[rocky 123]

Thanks Gor