Ok, I created a button with specific colors using visual basic and used the
code you gave. Now when I goto insert the button I can get it to link just
fine, but it has the "default" button appearance. How do I change this?

"Chip Pearson" wrote:

Create a macro like

Sub ShowSheet()
ActiveWorkbook.Worksheets("Sheet2").Select
End Sub

and attach that macro to your button.


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



"Benz" wrote in message
...
Im new at this, I need to create a button that when clicked
will bring up a
disignated sheet (at the bottom).

"Chip Pearson" wrote:

What exactly do you mean by "link to specific sheets"? Buttons
are linked to macros, not sheets.


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


"Benz" wrote in message
...
Can someone help me, I need to create a button to link to
specific sheets in
a workbook. I don't know how to create the right code.