I have lots of cell Comments in older Workbooks which I am busy converting to Notes - I prefer the simpler syntax for adding and deleting Notes in VBA, and I don't use any of the complex functionality in the new Comments.
As for formatting Notes (shape, size, location, font etc) I am just using the formatting syntax for Comments, which seems to work - as does the Collection of Comments which seems to include Notes.
I was wondering if there's a separate Notes Collection, and if there's specific formatting syntax for Notes instead of using the Comments formatting syntax ?
I have these questions because I can't find any decent documentation on managing Notes with VBA.
Grateful for any assistance.
As for formatting Notes (shape, size, location, font etc) I am just using the formatting syntax for Comments, which seems to work - as does the Collection of Comments which seems to include Notes.
I was wondering if there's a separate Notes Collection, and if there's specific formatting syntax for Notes instead of using the Comments formatting syntax ?
I have these questions because I can't find any decent documentation on managing Notes with VBA.
Grateful for any assistance.