Enter the word John in a cell on client sheet.

Right-click on that cell and "Hyperlink"

Place in this document.

Select John sheet and a cell to jump to and OK

Click on John in client sheet to jump to John sheet.

I don't understand the rest of it.............. "the code on start to quick in?"

Do you want some code to run after you have jumped to John sheet?

If so, sheet activate code can be placed in the module of John sheet.

Private Sub Worksheet_Activate()
'your code or a call to a macro goes here
End Sub


Gord Dibben MS Excel MVP


On Sun, 30 Sep 2007 03:47:18 -0000, Jean wrote:

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