mouse pointer as a hand

[Guest]

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

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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?

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

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.

 

[Guest]

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

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?

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

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.

:

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


:

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

 

[Guest]

Thanks a lot, Rowan.

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

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?

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

:

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.

:

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


:

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

 

[Guest]

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

 

[Guest]

Thanks, Patrick.

Where and how could I set up those properties?

 

[Patrick Molloy]

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

 

[Guest]

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?

 

[Chip Pearson]

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

in message