Deleting Notes when I save my file as a web page.

[SandsB]

If a cell has notes, when I save the file as a web page I don't see the red triangle in the cell anymore. But the notes are appended to the bottom of the web page. These notes need to be kept private so there should be no mention of them on the web page version. How do I remove the notes when they could be in any number of cells in a huge file?

 

[SandsB]

Correction. The web page show [1] etc for the notes. Need to delete all traces of all notes.

 

[SandsB]

Can someone let me know if it's not possible to do this?

 

[SandsB]

I couldn't find a better way so I'm turning comment visibility off in Excel, saving as a web page, then turning it back on. Clunky but it'll get the job done.
'Hide the Notes
Application.DisplayCommentIndicator = xlNoIndicator

'Make Notes visible
Application.DisplayCommentIndicator = xlCommentIndicatorOnly

 

[SandsB]

I couldn't find a better way so I'm turning comment visibility off in Excel, saving as a web page, then turning it back on. Clunky but it'll get the job done.
'Hide the Notes
Application.DisplayCommentIndicator = xlNoIndicator

'Make Notes visible
Application.DisplayCommentIndicator = xlCommentIndicatorOnly

CRAP. This doesn't work, either. The notes don't display on my screen but when the file is saved as a web page, the notes are still at the bottom of the page.