Hello all,
I'm currently making an excel spreadsheet that acts as a "dashboard" to useful information.
It currently contains over 200 worksheets and I would like for all of them to remain hidden unless a hyperlinked object is clicked on the "Main Menu" that opens them up.
Excel will not open hidden sheets when a hyperlink is clicked, unless a macro is written to do so, which I remain deficent in creating!
If someone could help it would be greatly appreciated!
*All of my hyperlinks to the worksheets are "pictures" or "objects" verus just text.
I'm currently making an excel spreadsheet that acts as a "dashboard" to useful information.
It currently contains over 200 worksheets and I would like for all of them to remain hidden unless a hyperlinked object is clicked on the "Main Menu" that opens them up.
Excel will not open hidden sheets when a hyperlink is clicked, unless a macro is written to do so, which I remain deficent in creating!
If someone could help it would be greatly appreciated!
*All of my hyperlinks to the worksheets are "pictures" or "objects" verus just text.
