Making and Managing List//Hiding Worksheets

  • Thread starter Thread starter SlimPickins
  • Start date Start date
S

SlimPickins

1.I've made a list but the source list appears on the worksheet, how
can I stop this?
2.I also have a worksheet set to be used as a source for list, how ca
I get this source to be used by other sheets/
3.If I can do the above how can I hide this sheet from being seen/

Slim
 
Hi
I think you're talking about data validation listsources. If this is
correct try the following:
- define a name for your source list: Select the range and goto
'Insert - name - define'
- use this name in the data validation listbox as data source
 
Back
Top