Hi,
I've found a quirk of Excel 2007 which I can't seem to overcome:
When a cell has:
1) a comment, and
2) data validation as a list, and
3) no "locked" status in the "protection" tab of the formatting window.
And when the worksheet containing this cell is protected, and the cell is selected...
Then when you hover your cursor over the cell, the comment doesn't pop up. (Note also that the cursor icon becomes the 'hand with a pointing index finger').
Two questions:
1) Why does this happen?
2) Is there any way to overcome this without using VBA? (ie is there a setting that can be adjusted)?
Thanks
Mark
I've found a quirk of Excel 2007 which I can't seem to overcome:
When a cell has:
1) a comment, and
2) data validation as a list, and
3) no "locked" status in the "protection" tab of the formatting window.
And when the worksheet containing this cell is protected, and the cell is selected...
Then when you hover your cursor over the cell, the comment doesn't pop up. (Note also that the cursor icon becomes the 'hand with a pointing index finger').
Two questions:
1) Why does this happen?
2) Is there any way to overcome this without using VBA? (ie is there a setting that can be adjusted)?
Thanks
Mark