filling combo boxes from single outer source

A

alekm

Hi,
I want to make a template with combo box on sheet 1. I can fill values for
combo from sheet 2 for example. But that way I'll end up with every single
file (made from that template) also with sheet 2 and all the stuff in it.
Is there any way I can store source for combo values out of template?
Thanx
 
K

Kevin B

You could still place the lookup values on sheet 2, but instead of hard
coding the values you could place formulas that link back to a globally
available workbook where the lookup values are maintained.

Additionally, you could name the range containing the combobox lookup values
and have a macro automatically read the range in upon opening.

Hope this kinda' points you in a useful direction...
 
Top