ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Comment indicators - web translation (https://www.excelbanter.com/excel-programming/322413-comment-indicators-web-translation.html)

Pat Russell

Comment indicators - web translation
 
Hi,

I have a summary data report in Excel, that has comments in certain cells
which I've populated using VBA to show lists of names when you hover over the
cell. I have Comment Indicators visible.

If I Save As Web Page, I was amazed to find that the comments are also
translated, which is great. However the Comment Indicators are no longer
subtle red triangles in the cell corner, they are numbers in square brackets
e.g. [99], which sit in front of the data they're attached to, obscuring the
view of the number.

I've had a look at the source, and it appears to be a javascript function,
but I can't work out exactly how they're displayed. Can anybody help? If I
could move the comment to the corner of the cell that would be great, or if
not, lose the indicator completely, but still have the popup text show when
the mouse hovers over a relevant cell, which I'll indicate in another way.

Lastly, I'm trying to automate as much of this as I can, so I don't actually
want to have to make changes to the web page source every time.

Thanks for any help.

Pat.


All times are GMT +1. The time now is 03:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com