View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Could I jump to another Sheet by clicking on a cell

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