Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 328
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking cells by name only to another worksheet.... Jkralick Excel Worksheet Functions 3 June 8th 06 02:01 AM
Linking a worksheet from a different excel file Trever B Excel Discussion (Misc queries) 1 May 11th 06 11:19 AM
Excel 2003 - Linking Formulas, Worksheet to Worksheet windsong Excel Discussion (Misc queries) 4 November 15th 05 03:10 PM
Comparing a list to a Calendar worksheet. PatrickL Excel Worksheet Functions 0 August 25th 05 04:21 PM
how do i use sumif when linking worksheet anushri Excel Discussion (Misc queries) 1 July 24th 05 12:57 PM


All times are GMT +1. The time now is 04:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"