Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default enhance trace precedent via dialogue box?

Hi Guys,
I am working mostly with a big messy file with plenty of sheets, cells are
linked to everywhere in other sheets or even other files.

My questions are; when i use trace precedent of a cell that link to other
sheets or other files excel will prompt an arrow with a little columnar box
indicating the link are outside of the current sheet.
When we double click the arrow it will prompt a "go to" dialogue box with
list of all links and state the location of the link i.e. File/sheet/cell.

Is it possible for the:
1. "go to" dialogue box not only stating the origin of the link i.e.
file/sheet/cell but also quoting the values??
2. If showing values is possible, would it be another posibilites that the
"go to" dialogue box can be turn into sort of floating box that capable of
doing its own excel sheet calculation and so forth?

Is this possible guys? i hope this os not too much...

thanks


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
alternate for Trace precedent zen Excel Worksheet Functions 5 March 16th 09 04:41 PM
trace precedent button grayed Duke City GS Excel Discussion (Misc queries) 1 April 16th 08 05:28 PM
Trace Precedent George Cuartero Excel Worksheet Functions 1 May 31st 07 04:19 AM
trace dependent tool doesn't work but trace precendent doesn't marnie Excel Discussion (Misc queries) 2 May 24th 07 12:26 PM
Excel Spreadsheet Trace Precedent Bars not showing up MarieM Excel Worksheet Functions 1 February 9th 07 07:57 PM


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