Comment Hover Over Status Bar

[JimmyA]

Hello All

Does anyone know if there is a way to change the status that appears in the bottom right hand corner of the screen when hovering over a commented cell?

by default it will say something like "Cell A1 Commented by Jimmya"

I can see how to change the status but this seems to be on until code switches it off or changes it to something else.

I am building up all the comments with VBA but I would need the status to be done without worksheet code as the final sheet would be sent out as a non macro file.

Cheers for any ideas

James

[LJMetzger]

Hi JimmyA,

After some research, I could find no way to eliminate the text that appears on the StatusBar. The 'StatusBar' can be made not visible, by either checking an Option or by using VBA:

Please Login or Register  to view this content.

Of course, since your EndUser is not using VBA, you have no control over whether the StatusBar is displayed or not.

There are two alternatives to Comments that I know of:

a. Screen Tip Text (sample code follows) which displays when Hovering over the cell, but the format can't be changed to the best of my knowledge.

Please Login or Register  to view this content.

b. Using Shapes that contain text, and using a MouseOver event to display or hide the Shape by Superimposing two transparent 'Active X' labels over the shape. This method requires VBA in the destination worksheet, so is not a viable alternative. For an example that changes Shape Color (it could make the shape visible and hidden) see: http://www.excelforum.com/excel-prog...ml#post3913584

-------------------------
Unfortunately, neither method is probably useful for your application.

Lewis