Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is there a way to create a comment for cell D7 (for example) such that when the user hovers over it the comment has a hot link or hyperlink to cell A100? I dont know what else to call it other than a hot link or hyperlink, however its not like the hyperlink we know of in HTML. Or, maybe it could it be?

The effect that is desired is that when the user sees that comment, he/she can click on the link to cell A100 if they choose to do so. I do not wish to create a macro or use VBA behind a button, etc.. It must be within the comment box itself.

One of the issues I have run into is that once you move the mouse, the comment goes away. The comment might be able to be displayed all the time if it needs to be for this to work.

share|improve this question

1 Answer 1

up vote 2 down vote accepted

No. Comments can only have text. You cannot even hover on a comment box. Comment boxes are only visible as long as you hover on the related cell. This is intentionally done by design. I don't know if you can change this behavior using a macro or addon, but this can be a feature request for the future releases of Excel.

share|improve this answer
    
I was hoping for a different answer but perhaps I shall make a feature request. I'll have to devise a workaround for the client. Thanks for the response! –  Electric Automation Apr 13 '10 at 12:14
    
You're welcome. –  Mehper C. Palavuzlar Apr 13 '10 at 12:54

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.