Sheet protection disables comments in data validated cells

  • Thread starter Thread starter Andy Brown
  • Start date Start date
A

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
 
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
 
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
-------------------------------------------------------------
 
EarlK,
I found that ...
If the cell is not selected, the
comment does appear on mouseover
Click to expand...

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.
Click to expand...

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
 
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
 
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
 
Back
Top