Hi
I am attempting to create a named range that will open individual sheets in a work book via a macro. The current method i am using is when a button is pressed the individual sheet for each person are displayed as in the example below.
Sheets("21534").Visible = True
Sheets("20722").Visible = True
Sheets("21160").Visible = True
Sheets("22031").Visible = True
Sheets("1503").Visible = True
What I would like to do is crate a named range that list the same sheets then call the named range in the macro to display the sheets from the named range. In the example below I create a named range called "Steve" the have the macro open the sheets from the name range. This would allow people who never used VBA to modify the displayed without having to go to the text editor to modify
<tbody>
</tbody>
Thanks again for all the help, this forum has pulled my fat out of the fire more times than I would like to admit to.
Chris
I am attempting to create a named range that will open individual sheets in a work book via a macro. The current method i am using is when a button is pressed the individual sheet for each person are displayed as in the example below.
Sheets("21534").Visible = True
Sheets("20722").Visible = True
Sheets("21160").Visible = True
Sheets("22031").Visible = True
Sheets("1503").Visible = True
What I would like to do is crate a named range that list the same sheets then call the named range in the macro to display the sheets from the named range. In the example below I create a named range called "Steve" the have the macro open the sheets from the name range. This would allow people who never used VBA to modify the displayed without having to go to the text editor to modify
Steve |
1503 |
20722 |
21160 |
21534 |
22031 |
<tbody>
</tbody>
Thanks again for all the help, this forum has pulled my fat out of the fire more times than I would like to admit to.
Chris