I am using this code to convert local hyperlinks to comments which have image background
Now I am facing a problem with comments position, I want to make all comments position to be fixed on the top right of an active window.
Please Login or Register to view this content.
I want that because I have long list and I want to comfort my eyes to just focus on the same area while hovering
Thanks in advance
Cross-posted at http://www.mrexcel.com/forum/excel-q...-position.html
Entia non sunt multiplicanda sine necessitate
The .Comment.Shape object also has .Top and .Left properties, you could use them with TargetRange's .Top, .Left, .Width and .Height properties to put the comment in its place.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thanks for your reply but could you please tell me more details, I am newbie to VBA stuff
Code like
can be added to the code in the OP.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks