rajatsingh78
New Member
- Joined
- May 17, 2005
- Messages
- 27
Hi Guys,
I am creating a workbook with multiple sheets, on the main sheet I have inserted a drop down menu using "Data Validation"-->List. Right now I select an item from the list and then a hyperlink comes up below the drop down box, I want to change this.
I want that as soon as I select an item from the drop down (by using data validation or any other method) the related sheet open up automatically.
Please help me in this.
Thanks in advance,
Cheers!!
Lucky
I am creating a workbook with multiple sheets, on the main sheet I have inserted a drop down menu using "Data Validation"-->List. Right now I select an item from the list and then a hyperlink comes up below the drop down box, I want to change this.
I want that as soon as I select an item from the drop down (by using data validation or any other method) the related sheet open up automatically.
Please help me in this.
Thanks in advance,
Cheers!!
Lucky