Ok..instead of using the worksheet tabs..
I want a user to be able to select which worksheet he/she wants to view..
Closest thing ive found so far is using a hyperlink.
Thing is i have 39 worksheets .and dont want all 39 hyperlinks displayed.
Is there anyway of using combo boxs or combination of combo box and option box and having the worksheet hyperlink displayed in a cell..
REASON i want this is i need a frontsheet for the user s..i know u can user tabs..
I want a user to be able to select which worksheet he/she wants to view..
Closest thing ive found so far is using a hyperlink.
Thing is i have 39 worksheets .and dont want all 39 hyperlinks displayed.
Is there anyway of using combo boxs or combination of combo box and option box and having the worksheet hyperlink displayed in a cell..
REASON i want this is i need a frontsheet for the user s..i know u can user tabs..