View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
ALEX ALEX is offline
external usenet poster
 
Posts: 493
Default mouse pointer as a hand

Thanks, Rowan.
I've entered this but anyway the message such as "[Book1]Sheet1!A1 - Click
once to follow. Click and hold to select this cell" appears.

How could I get rid of that as well and how I could have some word on that
cell as I have it making hyperlink from the tool's menu?

"Rowan" wrote:

Using the function you set the hypelink path as a string. You must provide
the full path for other workbooks or just the workbook name if the link is to
a cell in the current workbook. E.g if the hyperlink is in Book2 and
referencing a cell in Book2 then the formula would be
=HYPERLINK("[Book2]Sheet1!A1","").
The final "" means that no text will be shown in the cell

Regards
Rowan

"Alex" wrote:

Thanks, Sebastien.
I'm using the hyperlink tool from the menu and I couldn't find anything from
the help file.

So, if you can, please advise how I can do it.

"sebastienm" wrote:

Hi,
Are you using the HYPERLINK( ) function or the hyperlink tool from the menu?
As a function:
HYPERLINK( link , text_to_display )
the 'link' parameter can be a bit tricky sometimes.
check at the online help for more details.

Regards,
Sébastien


"Alex" wrote:

I'd like to have a mouse pointer as a hand when clicking some specific cells.
I'm trying to use hyperlink but don't know how to get rid of the the
hyperlink path showing.

Could anybody advise anything?

Thanks