Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default create a button to link

I would like to have two worksheet in the same workbook. When I click in the
cell name "Manufacture" that creates a link to the 2 sheet where all Point of
contacts. phone numbers, address, emails,
--
Jeannette
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 50
Default create a button to link

Select the "Manufacture" cell, and then do Insert / Hyperlink, or Ctrl-K. On
the Insert Hyperlink dialog box, choose Place in This Document on the left,
and you'll see all worksheets and named ranges in the middle. Choose what
you want, then click OK.

--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC



"Jeannette" wrote:

I would like to have two worksheet in the same workbook. When I click in the
cell name "Manufacture" that creates a link to the 2 sheet where all Point of
contacts. phone numbers, address, emails,
--
Jeannette

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
Create an attractive "link" button [email protected] Excel Programming 2 January 1st 07 11:57 PM
How to create a link by using command button in VB Dav Excel Discussion (Misc queries) 1 March 9th 06 12:23 PM
Create floating button based on button click in menu ExcelMonkey Excel Programming 2 October 12th 05 06:43 PM
automatically create a spinner and link it when a button is pressed jamesleggit Excel Programming 1 May 31st 05 08:57 PM
button link Marcel Excel Discussion (Misc queries) 1 March 17th 05 12:49 AM


All times are GMT +1. The time now is 12:34 PM.

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

About Us

"It's about Microsoft Excel"