Helen,

Put the following code behind your button.

With Worksheets("Sheet1")
.Visible = Not .Visible
End With

It will toggle Sheet1 between hidden and visible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Helen" wrote in message
...
Hi, I'm trying to figure out two things;

create a button that can hide/unhide sheets

create a button that can takes the user to another place in the
work book (even if that sheet is hidden) - maybe this is a
hyperlink of sorts?

(I know how to create the buttons, just need help big time(!)
with the code)

Thanks!

Helen