Linking one worksheet to another worksheet?

L

Lisa

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.
 
G

Gord Dibben

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
 
Top