Hi peeps, I was hopin someone cud enlighten me!! haha!
I need to create drop down menu in Excel that can help people navigate from one sheet 2 another. How can this be done. Are there ne articles that can put me in the right direction?
Thanks for ne hlp
James

Here are 3 ways to accomplish this.
1. Using VBA, create command buttons on your menu sheet and then
on the click function use the sheet2.open command.
2. Use a forms command button and assign a macro to that button that that has been recorded to move from sheet 1 to sheet 2
or
3. This is the easiest, use hyperlinks to the sheet from sheet1