Hi,
I have a file which used to work fine but now has a problem - the only difference is that I have upgraded from Excel 2010 to 2016 (which I guess must be the issue!?).
A wksht has some cells that have comments in them. The sheet is password protected to prevent the user 'breaking' anything. I have given users an option to show/hide the comment indicators using a macro button (the code is below). This used to work fine in Excel 2010 - the user would 'show' the comment indicators then hover to see the comments, when done they would then 'hide' the indicators. Any thoughts on why this is not working in Excel 2016?
I have a file which used to work fine but now has a problem - the only difference is that I have upgraded from Excel 2010 to 2016 (which I guess must be the issue!?).
A wksht has some cells that have comments in them. The sheet is password protected to prevent the user 'breaking' anything. I have given users an option to show/hide the comment indicators using a macro button (the code is below). This used to work fine in Excel 2010 - the user would 'show' the comment indicators then hover to see the comments, when done they would then 'hide' the indicators. Any thoughts on why this is not working in Excel 2016?
Code:
If Application.DisplayCommentIndicator = xlCommentIndicatorOnly Then
Application.DisplayCommentIndicator = False
Else
Application.DisplayCommentIndicator = xlCommentIndicatorOnly
End If
