ComboBox linking in with other worksheets

Shakeregg · #1 11-04-2018, 05:09 AM

Hey all,

If someone could help me with this I would really appreciate it.

I have a workbook (named Database) which contains 4 worksheets named Main, Leeds, Bradford, York. Ideally I would like to create a drop down list in Main which lists the other 3 worksheets which when selected will automatically take me to that worksheet.

i.e.

Select Option
- - - - - - - - -
Leeds
Bradford
York

Would it also be possible to hide the Leeds,Bradford& York worksheets so thy don't appear as tabs? So the only option for the user is to access these 3 worksheets (Leeds, Bradford, York) through the ComboBox?

Cheeeeeeeeers in advance

jeffreybrown · #2 11-04-2018, 06:59 AM

How about with no programming necessary...

NoSparks · #3 11-04-2018, 07:46 AM

Previously posted at:
https://www.mrexcel.com/forum/excel-...orksheets.html

Shakeregg · #4 11-04-2018, 08:06 AM

Yeah it doesn’t work unfortunately. Will try the hyperlink idea though.... good suggestion!!

Thanks both

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Fill userform, combobox and frame based on data from multiple worksheets	Divinedar	Excel Programming	8	04-26-2018 05:07 PM
Combobox	dweekley	Excel	3	05-25-2017 05:41 AM
Linking Combobox to multiple bookmarks	scarda	Word VBA	4	01-20-2015 10:48 PM
Linking Workbooks/Entire Worksheets to Identical in Master	taxacct	Excel	2	10-01-2014 11:22 AM
Linking text between worksheets	AndrewsGram	Excel	1	03-09-2010 01:26 PM