N
Nikhil
Hi.. i have a workbook with lots of sheets. I have a main sheet and
other supporting sheets. I want to have a drop down list in the
toolbar (only for this workbook) so that user can select which sheet
he wants to view.
By default only the main sheet should be visible and all others sheets
should be hidden.
When the user selects a particular sheet, that sheet & the main sheet
would become visible. when the user moves out from the particular
sheet, it should automatically become hidden.
I want a link to all the sheets in the main sheet (icons which the
user can click to reach a particular sheet) as also possibly a drop
down in the tool bar with all the sheets listed.
Please help. should this have to be done with a VBA code, request to
please be explicit since i am zero as far as VB goes.
Thanks
Nikhil
other supporting sheets. I want to have a drop down list in the
toolbar (only for this workbook) so that user can select which sheet
he wants to view.
By default only the main sheet should be visible and all others sheets
should be hidden.
When the user selects a particular sheet, that sheet & the main sheet
would become visible. when the user moves out from the particular
sheet, it should automatically become hidden.
I want a link to all the sheets in the main sheet (icons which the
user can click to reach a particular sheet) as also possibly a drop
down in the tool bar with all the sheets listed.
Please help. should this have to be done with a VBA code, request to
please be explicit since i am zero as far as VB goes.
Thanks
Nikhil