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

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

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

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

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

Hi Alex

I don't think you can remove the screen tip completely using either method.
If you use the Hyperlink tool you can set the screen tip to a single space by
clicking on the ScreenTip button. This will then show a small blank box on
the screen. Sorry, I think that's the best I can do.

Regards
Rowan

"Alex" wrote:

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

If you want to run a procedure - why else have a hand? - then you could place
a rectangle ( from the draing menu) over the cell. use the ALT key to set the
rectangle to the cell, assign a 'macro' and set the rectangles properties to
no line an no fill. Now when the mouse moves over the invisible rectangle,
it changes to a hand


"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

Thanks, Patrick.

Where and how could I set up those properties?



"Patrick Molloy" wrote:

If you want to run a procedure - why else have a hand? - then you could place
a rectangle ( from the draing menu) over the cell. use the ALT key to set the
rectangle to the cell, assign a 'macro' and set the rectangles properties to
no line an no fill. Now when the mouse moves over the invisible rectangle,
it changes to a hand


"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

right click when the shape is selected and choose format from the pop-up
menu

"Alex" wrote in message
...
Thanks, Patrick.

Where and how could I set up those properties?



"Patrick Molloy" wrote:

If you want to run a procedure - why else have a hand? - then you could
place
a rectangle ( from the draing menu) over the cell. use the ALT key to set
the
rectangle to the cell, assign a 'macro' and set the rectangles properties
to
no line an no fill. Now when the mouse moves over the invisible
rectangle,
it changes to a hand


"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

Patrick

How can you get a hand to show per cell - similar to what happens in a
browser. I want the mouse cursor to change when it is over a clickable cell
(ie: go or do something) but not when over other cells.

Is this as clear as mud?

"Patrick Molloy" wrote:

right click when the shape is selected and choose format from the pop-up
menu

"Alex" wrote in message
...
Thanks, Patrick.

Where and how could I set up those properties?



"Patrick Molloy" wrote:

If you want to run a procedure - why else have a hand? - then you could
place
a rectangle ( from the draing menu) over the cell. use the ALT key to set
the
rectangle to the cell, assign a 'macro' and set the rectangles properties
to
no line an no fill. Now when the mouse moves over the invisible
rectangle,
it changes to a hand


"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

There is no MouseOver event for a range, so there is no way to
detect what cell the mouse is over. Thus, you cannot change the
cursor for a single cell. The Cursor property is
application-wide, and doesn't support a Hand image anyways, so
you can't do what you want to do.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"gavins_satori" wrote
in message
...
Patrick

How can you get a hand to show per cell - similar to what
happens in a
browser. I want the mouse cursor to change when it is over a
clickable cell
(ie: go or do something) but not when over other cells.

Is this as clear as mud?

"Patrick Molloy" wrote:

right click when the shape is selected and choose format from
the pop-up
menu

"Alex" wrote in message
...
Thanks, Patrick.

Where and how could I set up those properties?



"Patrick Molloy" wrote:

If you want to run a procedure - why else have a hand? -
then you could
place
a rectangle ( from the draing menu) over the cell. use the
ALT key to set
the
rectangle to the cell, assign a 'macro' and set the
rectangles properties
to
no line an no fill. Now when the mouse moves over the
invisible
rectangle,
it changes to a hand


"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