hyperlinking the whole area of a cell ?????

[palaeontology]

I currently have hyperlinks (within a large number of cells) that link to places within the same document, but the cell sizes are, by necessity, quite small, and the hyperlinked letter inside each of the cells is even smaller, therefore very hard to click on quickly ... usually I'll miss the hyperlinked letter and click onto empty space inside the cell.

I may end up making a floating userform with a series of coded buttons to do the same job, but wanted to explore this first ...

Is it possible to have the entire space of a cell act as a hyperlink, so I can click anywhere in the cell and not have to be accurate with the placement of my cursor ?

Kind regards,

Chris

 

[shg]

For whatever reason, setting the vertical formatting of the cell to Distributed extends the clickable area to the entire cell width.

 

[palaeontology]

You are a genius, thankyou so much ... it worked perfectly.

Kind regards,

Chris

 

[My Aswer Is This]

That trick worked for me when I tested it. Great find.

For whatever reason, setting the vertical formatting of the cell to Distributed extends the clickable area to the entire cell width.

 

[shg]

Accidental discovery -- I meant to set the horizontal alignment to distributed (which doesn't work).

You're welcome.