Linking one worksheet to another worksheet?
 

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.

Linking one worksheet to another worksheet?
 

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.