Gord Dibben <gorddibbATshawDOTca wrote in
:

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




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