Command Button to open hidden sheet and close when de- selected

**Chris1976** · 05-05-2020, 05:15 AM

Hi There

I have a code below that I have on my index sheet. All my other sheets besides the INDEX sheet is hidden. As soon as i select the sheet name "Dashboard" on the index sheet hyperlinked to the "Dashboard" sheet it opens that sheet. When I click the index sheet again the open sheet "Dashboard" is hidden again

I want to change the code a bit and link it to a command button. The command buttons name will be DASHBOARD as soon as I select the command button I want want it to open the DASHBOARD sheet, when I then click the unhiden index sheet the DASHBOARD sheet will hide again

Could someone perhaps help me in the right direction

Please Login or Register  to view this content.

**sintek** · 05-05-2020, 05:23 AM

No sample file...Mind readers can help...

**LJMetzger** · 06-30-2020, 03:34 PM

Hi Chris,

Try the following code included in the attached sample workbook.

Please Login or Register  to view this content.

To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. Dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspx

Use 'Forms' CommandButtons - DO NOT use 'AcitveX' CommandButtons. ActiveX DOES NOT play nice with others.
To assign a Macro to a CommandButton, 'Right Click' the CommandButton.

Lewis