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.



"Robert Crandal" wrote in message
...
Our company has designed 4 different spreadsheet designs. The same
data gets stored in any of the 4 spreadsheet layouts....the only
difference
is that some spreadsheets use different colors, have different fonts and
cell sizes and etc...

I thought it would be nice to create just ONE spreadsheet that contains
a combo-box or list-box or drop-down box which allows the user to
select 1 of the 4 layout choices, then I want VBA to programattically
setup
the spreadsheet layout according to the users choice. Does that make
sense?

Does anybody know any good ways to implement something like this?? Right
now the only thing I can think of is create a huge "Select Case" statement
which
changes the spreadsheet properties/colors/cell sizes according to the
user's choice.

Please do give feedback. Thank you everyone!