pop up window

[MetLife]

Hi,

I am using an excel document that was created by another person.

It has a feature where a comment like window pops up when I highlight a cell.

I am not familiar with this feature, but I want to delete it. Since I don't know what it is I can't. Does anyone know what the feature could be and how to disable it.

It is not a regular comment.

Thanks

 

[Joe4]

Right-click on the Sheet tab name at the bottom of the screen and select View Code.
Do you see any VBA code? The one you are looking for probably begins with this line:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

 

[philwojo]

Sounds like some kind of possible VBA code or Macro, what is the extension of your file?

 

[RoryA]

That sounds like a Data Validation prompt to me. Check the DV settings for the cell.

 

[MetLife]

No, I clicked on the sheet and there is no underlying code.

The extention is .xls

 

[Joe4]

No, I clicked on the sheet and there is no underlying code.

Did you see Rory's comments?

 

[MetLife]

That sounds like a Data Validation prompt to me. Check the DV settings for the cell.

Yes it was a data validation prompt. I'm unfamiliar with these they must be a new feature in 2010.

Thanks

 

[RoryA]

No, they've been around for a while.