hide comments on mouse hover
Hi all,
I need to somehow achieve the following; I think I am almost there but am struggling with the Workbook_Open coding.
1) On Workbook_Open - I need to hide all comments from being shown including on mouse hover
2) On cell range selection and button click
e.g. Range A11 selected and toggle button "show/hide comments" is clicked
3) comments for that cell are then either shown or hidden dependant on toggle condition
Many Thanks,
H
Posted by Error
Last edited by mehmetcik; 01-16-2017 at 04:58 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Hello hemal89,
Here is the working code for what you want to do. The draw back is the comment indicator (red triangle) has to be hidden. Anytime the indicator is visible, Excel will not yield control to VBA.
ThisWorkbook Module
ActiveX Toggle Button Code
Please Login or Register to view this content.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks