57 votes21 comments · Excel for Windows (Desktop Application) » Graphics · Flag idea as inappropriate… · Admin →
I confirm that the code provided below met my needs as well. I, too, was able to easily modify it for my application. I am grateful for the generous assistance.
At this point, I only want to acknowledge receipt of the further recommendation and my gratitude for your prompt attention to the question. I'll work with it over the upcoming holiday to install and modify it into my main application.
Thanks again. I never cease to be amazed at the generous way that so many share their expertise.
Eric Tabor, thanks for taking up this issue. I've also been dinking around with the code referenced by Col Delane and agree that it does resize, but does not seem to relocate the comment closer to "home". Not that I'm "fluent" in coding, but as I read, re-read, and step through the macro, I'm at a loss to see how it even addresses the location of the comment. Can anyone help me understand how/where that is alleged to be taking place?
I'd be grateful if I could change the default setting on "Format Comment" Properties to either of the other two "Object positioning" options when I start a new workbook.Bob supported this idea ·