Cell Comment Sticks While Using Validation
 

Hi,

While using validation to create drop-down menus, I have encountered a very
annoying problem. Everytime I open the files in question anew and click on a
cell, one of the cell comments on the worksheet becomes unhidden and hovers
over any cell that I click, completely obscuring it. Because of this, I
can't use any of the drop down menus. The program is essentially frozen at
this point. I can fix the problem by deleting the comment on the offending
cell, but everytime I open the file anew, the problem persists with another
comment on another cell.


Does anyone know why this is happening/how to permanently fix the problem?

Cell Comment Sticks While Using Validation
 

Those may be data validation input messages, instead of comments. If you
don't need them, you can turn them off. There are instructions he

http://www.contextures.com/xlDataVal04.html

Pugmalion1 wrote:
Hi,

While using validation to create drop-down menus, I have encountered a very
annoying problem. Everytime I open the files in question anew and click on a
cell, one of the cell comments on the worksheet becomes unhidden and hovers
over any cell that I click, completely obscuring it. Because of this, I
can't use any of the drop down menus. The program is essentially frozen at
this point. I can fix the problem by deleting the comment on the offending
cell, but everytime I open the file anew, the problem persists with another
comment on another cell.


Does anyone know why this is happening/how to permanently fix the problem?




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Cell Comment Sticks While Using Validation
 

I think that may be it! Now why couldn't any of the IT guys in my company
find something so simple? And why would Excel toggle those things on as a
default if it just screws everything up?

You don't need to answer those questions, too.

Thanks for your help!




"Debra Dalgleish" wrote:

Those may be data validation input messages, instead of comments. If you
don't need them, you can turn them off. There are instructions he

http://www.contextures.com/xlDataVal04.html

Pugmalion1 wrote:
Hi,

While using validation to create drop-down menus, I have encountered a very
annoying problem. Everytime I open the files in question anew and click on a
cell, one of the cell comments on the worksheet becomes unhidden and hovers
over any cell that I click, completely obscuring it. Because of this, I
can't use any of the drop down menus. The program is essentially frozen at
this point. I can fix the problem by deleting the comment on the offending
cell, but everytime I open the file anew, the problem persists with another
comment on another cell.


Does anyone know why this is happening/how to permanently fix the problem?




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Cell Comment Sticks While Using Validation
 

I may have spoken too soon. I turned off the input messages on all of the
sheets, saved, and clicked a cell, and I had the same problem. It's
definitely a case of a cell comment unhiding and obscuring any cell that I
click. If I highlight the comment as if I was going to edit the text and
then press "delete", It deletes the comment and fixes the problem until the
next person accesses the sheet, but at the rate these sheets are going to
accessed, there won't be any cell comments left in a week's time.

I have to use them quite often in order to list extenuating information, so
not using them isn't an option I'd like to consider.

Do you or does anyone else have any other ideas? It's diriving me crazy.






"Debra Dalgleish" wrote:

Those may be data validation input messages, instead of comments. If you
don't need them, you can turn them off. There are instructions he

http://www.contextures.com/xlDataVal04.html

Pugmalion1 wrote:
Hi,

While using validation to create drop-down menus, I have encountered a very
annoying problem. Everytime I open the files in question anew and click on a
cell, one of the cell comments on the worksheet becomes unhidden and hovers
over any cell that I click, completely obscuring it. Because of this, I
can't use any of the drop down menus. The program is essentially frozen at
this point. I can fix the problem by deleting the comment on the offending
cell, but everytime I open the file anew, the problem persists with another
comment on another cell.


Does anyone know why this is happening/how to permanently fix the problem?




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Cell Comment Sticks While Using Validation
 

Are there macros in the workbook? Perhaps a macro is showing the active
cell's comment when you select a cell.

To check for code, right-click on the sheet tab, and choose View Code.

Pugmalion1 wrote:
I may have spoken too soon. I turned off the input messages on all of the
sheets, saved, and clicked a cell, and I had the same problem. It's
definitely a case of a cell comment unhiding and obscuring any cell that I
click. If I highlight the comment as if I was going to edit the text and
then press "delete", It deletes the comment and fixes the problem until the
next person accesses the sheet, but at the rate these sheets are going to
accessed, there won't be any cell comments left in a week's time.

I have to use them quite often in order to list extenuating information, so
not using them isn't an option I'd like to consider.

Do you or does anyone else have any other ideas? It's diriving me crazy.






"Debra Dalgleish" wrote:


Those may be data validation input messages, instead of comments. If you
don't need them, you can turn them off. There are instructions he

http://www.contextures.com/xlDataVal04.html

Pugmalion1 wrote:

Hi,

While using validation to create drop-down menus, I have encountered a very
annoying problem. Everytime I open the files in question anew and click on a
cell, one of the cell comments on the worksheet becomes unhidden and hovers
over any cell that I click, completely obscuring it. Because of this, I
can't use any of the drop down menus. The program is essentially frozen at
this point. I can fix the problem by deleting the comment on the offending
cell, but everytime I open the file anew, the problem persists with another
comment on another cell.


Does anyone know why this is happening/how to permanently fix the problem?




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Cell Comment Sticks While Using Validation
 

No, no macros...

I don't use them for these files because they are already fairly large and
take a good deal of time to load. With as much manipulation as they are
going to need, a macro would just cause me heacaches when I QC them.

It's not the comment on the cell that I click that becomes unhidden; it's
just one random comment somewhere on the sheet, and it follows me to any cell
that I click, even if it's on the complete opposite side of the sheet. It
basically shrinks and forms itself to about the size of the cell and hovers
directly over the top of any cell I select. It's a very strange problem, and
I've yet to find a permanent fix.

Cell Comment Sticks While Using Validation
 

If you copy that sheet to a new workbook, does the problem persist?


Pugmalion1 wrote:
No, no macros...

I don't use them for these files because they are already fairly large and
take a good deal of time to load. With as much manipulation as they are
going to need, a macro would just cause me heacaches when I QC them.

It's not the comment on the cell that I click that becomes unhidden; it's
just one random comment somewhere on the sheet, and it follows me to any cell
that I click, even if it's on the complete opposite side of the sheet. It
basically shrinks and forms itself to about the size of the cell and hovers
directly over the top of any cell I select. It's a very strange problem, and
I've yet to find a permanent fix.




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Cell Comment Sticks While Using Validation
 

Yes. I've had to copy a couple of them already because the abovementioned
problem had caused the validation to freeze in one cell, and it could not be
fixed by re-validating. After copying to a new workbook and saving and
re-entering the file, the problem started anew.

I'm currently at work creating these files, so if you can think of anything
worth trying, I'll give it a shot.

Cell Comment Sticks While Using Validation
 

If you can email me a copy of the sheet, with dummy data, I could take a
look. Remove the XSPAM from my email address.

Pugmalion1 wrote:
Yes. I've had to copy a couple of them already because the abovementioned
problem had caused the validation to freeze in one cell, and it could not be
fixed by re-validating. After copying to a new workbook and saving and
re-entering the file, the problem started anew.

I'm currently at work creating these files, so if you can think of anything
worth trying, I'll give it a shot.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html