I am trying to set up a (simple?) routine that asks a user to select their name from a combo box then go to a sheet based on their selection. So the name they select in the combo box goes into cell c11 and I use a vlookup formula "=VLOOKUP(C11,PEOPLEDATA,5)" on the range of alphabetically listed names to give me the name of the sheet I want to goto in cell d11. Then I'm stuck for the code that will take me to the page identified in cell d11.
Can it be done directly from the combo box selection?
Ultimately this will be in a protected / shared workbook (2010)