Lisa

Have you thought of just inserting a hyperlink on sheet1 to sheet3?

Otherwise you would need a macro to bring up sheet3.

Sub sheet3()
Sheets("Sheet3").Activate
End Sub

Assign to a button from the "Forms" toolbar.


Gord Dibben MS Excel MVP

On Mon, 30 Oct 2006 09:38:02 -0800, Lisa wrote:

I want to link a "button" from worksheet 1 to a Word object in worksheet 3.
So when they click on this "button" it will bring up this worksheet.