Hi, I have four buttons in my excel that show sheets using macro. The button works in the below way:
D1 - Shows Sheet1, Sheet 3, Sheet 7
D2 - Shows Sheet2, Sheet 4, Sheet 6
D3 - Shows Sheet5, Sheet 8,
D4 - Shows Sheet D9
For now we have hard-coded the values in the code about which sheets will open. Now we need to automate this so that there is an excel sheet A in the same file.
This sheet A will have list of button names and sheets to view. Our code should be taking the list of tabs from this sheet.
coding should be like which allow us to maintain this if we decide changes in grouping are needed.
D1 D2 D3 D4
Sheet 1 Sheet 2 Sheet 5 Sheet9
Sheet 3 Sheet 4 Sheet 8
Sheet 7 Sheet 6
Any help would be appreciated.
Thanks
Preeti Jha
D1 - Shows Sheet1, Sheet 3, Sheet 7
D2 - Shows Sheet2, Sheet 4, Sheet 6
D3 - Shows Sheet5, Sheet 8,
D4 - Shows Sheet D9
For now we have hard-coded the values in the code about which sheets will open. Now we need to automate this so that there is an excel sheet A in the same file.
This sheet A will have list of button names and sheets to view. Our code should be taking the list of tabs from this sheet.
coding should be like which allow us to maintain this if we decide changes in grouping are needed.
D1 D2 D3 D4
Sheet 1 Sheet 2 Sheet 5 Sheet9
Sheet 3 Sheet 4 Sheet 8
Sheet 7 Sheet 6
Any help would be appreciated.
Thanks
Preeti Jha