Like I said before:
You cannot hyperlink buttons to sheets.
You said:" i have 10 worksheets. 1 of which will be my dashboard containing buttons that are hyperlinked to the other 9 sheets."
Maybe your not familiar with Macros and how they work.
If you want a button to perform some sort of action you put a Macro script in the button and when you click on the button some action takes place.
Why you keep insisting you can create a hyperlink to hide sheets is beyond me. If you know how to do this please tell me how.
If you want a button which when clicked on will hide sheet (3) for example you need a script like this:
Code:
Sheets(3).Visible = False
Right click on your button. Choose "Assign Macro" and paste in this code.
Now when you click on the button sheet(3) will be hidden
Now if this is what you want explain more about what you want in total.
And you need to explain what type button your using.
When asking for help here you need to give specific details.
There are shape buttons, Activex command buttons, and Form control buttons.
And your Workbook will need to be saved as Macro Enabled.