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!