Re: Excel drop down menus
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
3. This is the easiest, use hyperlinks to the sheet from sheet1
Originally posted by jaime1985
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
KnightShift Office Solutions and Horse Breaking
VB, VBA, FileMaker, Access Solutions, Web Solutions