View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Rich/rerat Rich/rerat is offline
external usenet poster
 
Posts: 39
Default Can I click on a cell on one worksheet and make it take me to another worksheet

Gord,
I did not see those references on how to build a navigation toolbar, in your
previous posting. And it would be something like I would do since I'm a
novice with Excel.

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) <message rule
<<Previous Text Snipped to Save Bandwidth When Appropriate


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Yes, you could do that but to my way of thinking why go those extra steps to
make a hyperlink on each sheet to go back to Index sheet to pick another
sheet.

You can use the right-click on the navigation arrows or build a Navigation
Toolbar as per Dave's code on Debra Dalgleish's site.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob
Phillips.

http://tinyurl.com/yoa3dw


Gord

On Sat, 26 Jan 2008 00:37:23 -0500, "Rich/rerat" wrote:

Gord Dibben,
Wouldn't you place a hyperlink on each sheet, back to the Index Sheet?