can there be multiple buttons to hide/unhide a worksheet

[colinheslop1984]

I am wondering if there can be buttons on multiple worksheets to hide or unhide a single worksheet?

ThisWorkbook.Worksheets("jun payroll").Visible = xlSheetVisible

for example the code above makes jun payroll visible using a button on sheet1, but can sheet2 have the a button to make the same sheet visible or hidden?

I have tried creating a button and using the same code but it didnt work

 

[JoeMo]

You can use the same button on any sheet - just copy it from the sheet it was created on and paste to other sheets.