Sheet protection disables comments in data validated cells

[Andy Brown]

It seems that when a cell with data validation is selected, a comment
attached to the cell will not show if the ws is protected (XL2K, haven't
tried other versions).

Can anyone suggest a workround/alternative for this?

TIA,
Andy

 

[Phil C]

Hi Andy

I can't reproduce your problem, but I am using XL version 2002. So
presumably an 'old' problem which MS got around to fixing?
Not much consloation, I know, but maybe someone using XL2K will chip in with
a workaround..

Phil

 

[EarlK]

Phil, Andy,

I found that with XL97 and with XLXP, the comment does in fact not appear if
the cell is selected. This is with cells with Validation dropdowns (list),
and the sheet is protected, as Andy said. If the cell is not selected, the
comment does appear on mouseover of that cell (hover). Probably not useful
in this situation. Or most any. How in the world did "mouseover" get into
our lexicon?

The only solution that comes to mind is to put something instead of the
comment via VBA, using the Worksheet_SelectionChange event. Have it unhide
an adjacent column or insert a row under it and write the "comment" into it,
or put up a text box or something. It will have to remove it on a
subsequent cell selection. SOunds like a whole career. In short, do it
yourself.

Regards from Virginia Beach,

EarlK
-------------------------------------------------------------

 

[Andy Brown]

EarlK,

I found that ...
If the cell is not selected, the
comment does appear on mouseover

Yes, that's what I found -- on 2K.

The only solution that comes to mind is to put something instead of the
comment via VBA, using the Worksheet_SelectionChange event.

Never thought of that. Maybe on cell select run a msgbox might be better.
It's for a user so I'll try it out, if it's a requirement.

TVM for your suggestion,
Andy

 

[Tom Ogilvy]

It has never caused a problem for me.

I guess it depends on what they do (if one performs an action that triggers
the other and vice versa - that would be nasty).

Putting up a message box shouldn't cause a problem.

Regards,
Tom Ogilvy

 

[Andy Brown]

EarlK and Mr O,

I discovered it by accident since I had wb_Open jump to a cell with
validation and a comment ... effectively disabled the comment on mouse_over.

TVM for the advice & confirmation.

Rgds,
Andy