Well, I was hoping to avoid file open operations. I kind of just
wanted the spreedsheet to transform itself "on the fly" or
immediately when a user makes a listbox selection or something.

So, my current code idea would look as follows:

Select Case spreedsheet_choice
Case 1:
Columns(1).ColumnWidth = 12
Columns(2).ColumnWidth = 12
Columns(3).ColumnWidth = 12
Cells(1, 1).Value = "Name"
Cells(1, 2).Value = "Age"
Cells(1, 3).Value = "Sex"
Cells(1, 1).Interior.ColorIndex = 3
Cells(1, 2).Interior.ColorIndex = 3
Cells(1, 3).Interior.ColorIndex = 3
' etc etc
Case 2:
Columns(1).ColumnWidth = 5
Columns(2).ColumnWidth = 5
Columns(3).ColumnWidth = 5
Cells(1, 1).Value = "Client Name"
Cells(1, 2).Value = "Age"
Cells(1, 3).Value = "M/F"
Cells(1, 1).Interior.ColorIndex = 4
Cells(1, 2).Interior.ColorIndex = 4
Cells(1, 3).Interior.ColorIndex = 4
' etc etc
Case 3:
' etc etc...
Case 4:
' etc etc
End Select


Would the code above be just as effective as your method of loading
a template file??? Is my method above too complicated??

What do you think??

Thank you!


"JLGWhiz" wrote in message
...
You could make four templates and simply give the user a choice of which
template to use. The template would have to be saved as a different file
name than the template, but if it is a true template file (.xlt), it will
require that the user do that. Then you could use a listbox or combobox
with the four choices and when the user selects, it runs a macro to open
the xelected template.