View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jean[_6_] Jean[_6_] is offline
external usenet poster
 
Posts: 7
Default Could I jump to another Sheet by clicking on a cell

"Ron Coderre" wrote in
:

You may not need a program to accomplish what you want.
Try a hyperlink:

From the Excel Main Menu: <insert<hyperlink
Enter the text to display
Click the [Place in this Document] button
Select the sheet and cell to link to
Click the [OK] button

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Jean " <morlan(; wrote in message
.70...
Hi,

I would like make a code to Jump from one Sheet (Sheet(client)For
example) to another Sheet (sheet(john)for example) only by clicking
on specific Cell on sheet(client), the text in cell(john) will be
the name of the already created sheet(john)& when sheet(john) become
the active sheet the code on start to quick in?
What I really need to know is if I can call a code by clicking on a
specific cell in a worksheet?
Thank you.

Jean





Thank you for your response.
This solution is good but I have something as 300 links to do &
I was thinking more as something as ListBox but without Lisbox (cliking
directly in WorkSheet(Client) on the name of the client"John" to call a
code which make a search trough all sheets in the workbook to find the
Sheet with the same name as the one I clicked on the Sheet(Client).
Any Idea?
Thank a lot anyway.

Jean