I want selection for worksheet on base of Option button selection
With That User can select which type of Worksheets he want to see. Following are 3 options.
following 3 will be option buttons or check boxes
1) Hotel
2) Park
3) All
After opening file User must select any one option from above option button
If user will select first Option button (Hotel) then
All worksheets which names are ending with word "Hotel" only will be visible
If user will select Second Option button (Park) then
All worksheets which names are ending with word "Park" only will be visible
If user will select Third Option button (All) then
All worksheets will be visible
Please provide solution in Excel 2010 Version
Thanks in Advance
Bookmarks