button to hide worksheet

[colinheslop1984]

If i create a button, how can I make it hide a particular worksheet when clicked? and vice verse, a button that will unhide it

 

[Fluff]

How about

Sub colinheslop()
   With Sheets("[COLOR=#ff0000]Pcode[/COLOR]")
      .Visible = Not .Visible
   End With
End Sub

Change sheet name to suit.
This will hide the sheet & the next time the buttons clicked it will unhide the sheet