G Guest Oct 26, 2003 #1 when a user select a option from a drop down menu on my worksheet I want excel to move to the worksheet that refers to that selection- how can I do this?
when a user select a option from a drop down menu on my worksheet I want excel to move to the worksheet that refers to that selection- how can I do this?
E Earl Kiosterud Oct 26, 2003 #2 Sarah, You can define a name for the range (of cells), then open the range name box (left of the formula bar). You can right-click any of the four sheet-scroll buttons, which will result in a list of sheet names, and go to a sheet by sheet name. You can put buttons (pretty much any graphic object) on the worksheet that goes to the sheet (and to specific cells) via macros. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- sarah said: when a user select a option from a drop down menu on my worksheet I want Click to expand... excel to move to the worksheet that refers to that selection- how can I do this?
Sarah, You can define a name for the range (of cells), then open the range name box (left of the formula bar). You can right-click any of the four sheet-scroll buttons, which will result in a list of sheet names, and go to a sheet by sheet name. You can put buttons (pretty much any graphic object) on the worksheet that goes to the sheet (and to specific cells) via macros. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- sarah said: when a user select a option from a drop down menu on my worksheet I want Click to expand... excel to move to the worksheet that refers to that selection- how can I do this?
