Hi There,
I have 4+ hidden sheets in workbook ( Jan~Mar Just created for sample) +1 Menu Sheet.
Menu sheet has dropdown of Month Jan~Mar.
I want user to select any month and that particular sheet need to be unhide, keep rest of the sheet hidden as well as hide menu sheet as well, in case user selects Back to Menu in any of the sheet VBA should unhide only Menu sheet and rest of the sheets go to hidden.
Menu Sheet
Dropdown is in Cell A2
Rest of the Month Sheets
Back to Menu is in Cell D2
Could you please help me build suitable VBA.
Thanks & Regards,
Sanket
I have 4+ hidden sheets in workbook ( Jan~Mar Just created for sample) +1 Menu Sheet.
Menu sheet has dropdown of Month Jan~Mar.
I want user to select any month and that particular sheet need to be unhide, keep rest of the sheet hidden as well as hide menu sheet as well, in case user selects Back to Menu in any of the sheet VBA should unhide only Menu sheet and rest of the sheets go to hidden.
Menu Sheet
Dropdown is in Cell A2
Rest of the Month Sheets
Back to Menu is in Cell D2
Could you please help me build suitable VBA.
Thanks & Regards,
Sanket