View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Can I click on a cell on one worksheet and make it take me to another worksheet

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?