You would just add code to activate those sheets in the button click events,
such as

Worksheets("Data").Activate

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"RSHF" wrote in message
...
I have three sheets in my workbook and I am trying to enable two command
buttons on the first sheet(Summary) to link to the two other sheets (Data
and
Table) within the book. Does anyone know how to do this?