Comment Boxes and Gridlines

[Andyo]

I have created a database of fungi records in Excel 2000 incorporatin
comment boxes. When I save the workbook as a webpage the comment boxe
are not aligned with the names they are supposed to be linked to? als
is it standard that the gridlines do not appear when saved as
webpage, as my definitly haven't and I would prefer that they wer
present. I would appreciate some help if possible

 

[David McRitchie]

Hi Andy,
HTML will show borders but your gridlines will be ignored
even if you have checked Print gridlines on your setup, sheets
it has nothing to do with HTML, sorry.

Comment boxes will not appear in HTML either. If you were doing
your own conversion, the closest I can think of would be to have
a real hyperlink and to assign a Title="my comments" which would
appear momentarily as a ToolTip. But I don't think there is anything
you can do along those lines as Save As HTML in Excel.
Examples of what you get with title can be seen at the top of my
Search page (see signature line) by passing cursor over any of
to quick links on the top line after the heading..

What you can do is run a macro to create another worksheet that
has the address on the original sheet, the value and text value.
You will find several examples on
http://www.mvps.org/dmcritchie/excel/ccomment.htm
http://www.contextures.com/xlcomments03.html#CopyToSheet