Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Noshorts
 
Posts: n/a
Default i want to insert a link to another sheet tab

I want to insert a link into a cell, in Excel, that, when clicked, will take
me to and display another sheet within ths same workbook. Can anybody help me
to achieve this action ? ? ? ?
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

Have a look in help for HYPERLINK or create a macro with application.goto
sheet1!a1 and assign to a button or shape.

--
Don Guillett
SalesAid Software

"Noshorts" wrote in message
...
I want to insert a link into a cell, in Excel, that, when clicked, will

take
me to and display another sheet within ths same workbook. Can anybody help

me
to achieve this action ? ? ? ?



  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Right-click on the cell and select "Hyperlink"

From options pick "Within this document"

Chhose what yow wish.

Gord Dibben Excel MVP

On Sat, 4 Dec 2004 10:55:03 -0800, "Noshorts"
wrote:

I want to insert a link into a cell, in Excel, that, when clicked, will take
me to and display another sheet within ths same workbook. Can anybody help me
to achieve this action ? ? ? ?


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
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 06:57 PM
How do I insert a scroll bar into the excell sheet? Jason S Excel Worksheet Functions 2 December 1st 04 01:08 AM
Function to automatically insert a new sheet as a result of data entry? Mark Mulik Excel Worksheet Functions 2 November 28th 04 02:21 AM
insert a bitmap to the background of a spread sheet damanijackson Excel Worksheet Functions 2 November 22nd 04 04:04 PM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


All times are GMT +1. The time now is 09:23 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"