Hiding and unhiding worksheets using a single page of buttons

[edbarton]

Hi guys,

I am new to all this and I am trying to build a workbook with a title page that has buttons or shapes that link to each of the worksheets with in the workbook. I would like the sheets to be hidden until the button is clicked once the specific sheet is finished with I would like a back button to go back to home and close the worksheet again.

I have tried to achieve this by copying various code from this and other sites but nothing I try seems to work, i am obviously doing something wrong but tearing my hair out as I can't work out what...............ssssssssssssooooooooooooo frustrated please help. I would like to know the process as I would like to be able to add worksheets at a later date etc.

I have attached the workbook I have been working on.

Many many thanks
Ed

 

[vletm]

edbarton
Why did You duplicate Your thread?
You had opened yesterday:

Hide Unhide Worksheets using a button for each worksheet

Hi I am looking for a simple workbook that has a a number of worksheets hidden with a front sheet with a button to each worksheet that hides and unhide each worksheet. I found one on the forum but I cant work out how to edit the tab and button title to suit my needs. Many thanks for your help. Ed

chandoo.org

Now, I've to close that.

 

[Marc L]

Hi,​

​

as it's at beginner level I can't stand how can it be possible to not well read & copy any code​

but for sure coping / pasting can't be coding as it needs to warm at least a couple of neurons …​

​

As a first training : paste the below VBA procedure to the ThisWorkbook module of your attachment then once done​

select any tab different than Home tab then select the Home tab or use the Home button : the previous selected tab is now hidden.​

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
    If Sh.Index > 1 Then Sh.Visible = xlSheetHidden
End Sub

Do you like it ? So thanks to click on bottom right Like !​

​

 

[S. Das]

edbarton
I think you want something like this.......

If any password needed, the password will be "123".

 

[edbarton]

Thanks S. Das that is exactly what I am looking for. how would I add additional buttons and worksheets.

 

[edbarton]

Hi,​

​

as it's at beginner level I can't stand how can it be possible to not well read & copy any code​

but for sure coping / pasting can't be coding as it needs to warm at least a couple of neurons …​

​

As a first training : paste the below VBA procedure to the ThisWorkbook module of your attachment then once done​

select any tab different than Home tab then select the Home tab or use the Home button : the previous selected tab is now hidden.​

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
    If Sh.Index > 1 Then Sh.Visible = xlSheetHidden
End Sub

Do you like it ? So thanks to click on bottom right Like !​

​

Thank you, that works well but the links don't open the hidden sheets.

 

[S. Das]

Thanks S. Das that is exactly what I am looking for. how would I add additional buttons and worksheets.

You are welcome.
By the way, I don't understand your question about worksheet and button. You can add any shape as per your wish and after assign macro by right click on it you can use the shape as a button. Please refer the file I shared above. You can also get VBA code of hide and unhide of a sheet from the file.

 

[Marc L]

Thank you, that works well but the links don't open the hidden sheets.

You must allocate a VBA procedure to each button which unhides first the sheet according to the text button but no typo is allowed !​

​