Hello,
I have seen similar questions to this in the past but i have one slight difference.
I would like to use a drop down selection box which will make a sheet either visible or hidden based on the selection of "yes" or "no".
On sheet 1 I would like to list all the sheet names in the workbook and then, if column B is yes, then the sheet is visible, if it is no then the sheet is hidden.
Sheet one would look like:
[TABLE="width: 121"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Sheet Name[/TD]
[TD]Selection[/TD]
[/TR]
[TR]
[TD]Sheet1[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]Sheet2[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]Sheet3[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]Sheet4[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]Sheet5[/TD]
[TD]Yes
[/TD]
[/TR]
</tbody>[/TABLE]
I do not want to hardcode the names into the macro because I want the freedom to use this quickly on multiple workbooks, so the code needs to be able to read the sheet name in column a, store it, then run though the sheet names to hide that specific sheet.
Thanks in advance.
I will keep trying and post here if I come up with an answer.
I have seen similar questions to this in the past but i have one slight difference.
I would like to use a drop down selection box which will make a sheet either visible or hidden based on the selection of "yes" or "no".
On sheet 1 I would like to list all the sheet names in the workbook and then, if column B is yes, then the sheet is visible, if it is no then the sheet is hidden.
Sheet one would look like:
[TABLE="width: 121"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Sheet Name[/TD]
[TD]Selection[/TD]
[/TR]
[TR]
[TD]Sheet1[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]Sheet2[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]Sheet3[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]Sheet4[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]Sheet5[/TD]
[TD]Yes
[/TD]
[/TR]
</tbody>[/TABLE]
I do not want to hardcode the names into the macro because I want the freedom to use this quickly on multiple workbooks, so the code needs to be able to read the sheet name in column a, store it, then run though the sheet names to hide that specific sheet.
Thanks in advance.
I will keep trying and post here if I come up with an answer.