creating new spreadsheet and naming it

[somenoob]

hi everyone, i have a problem.

In Visual Basic Editor, how do i code it so that i can create a new spreadsheet with the name 'chk' and having numbers behind it everytime i want a new spreadsheet.

like if i click a button, chk1 is created, then click again, chk2 is created and so on..

also, when the spreadsheet is created, there is a template there already.

 

[SydneyGeek]

Welcome to the Board!

When you create chk1, chk2, ... are they new, empty sheets or do you want them to be based on an existing template sheet?

Denis

 

[somenoob]

Thank you!

they have a existing template

like in chk 1 in A1 there is the word Failure
but in A2 there is a word Service taken from the spreadsheet 'List' in A17

 

[somenoob]

also is it possible to add background colors to it?