Mystery Cell Properties

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A co-worker is getting prompted "would you like to input data" when clicking
on a column or cell in an excel spread sheet that was sent to him from
another vendor.

I cleared the data validation and the formatting within the cells, but that
did not work.

Also, the settings are cell/location specific and not content or data
specific. For example, if a column is inserted, the settings would apply to
the inserted column and not to the existing column.

Anyone have any idea what's causing this and/or how to rectify the issue?

This is an Excel 97 file.
 
HI HCK

Maybe there is a change event in the worksheet module
Right click on a sheet tab and choose view code.
 
Actually, I forgot to mention that I did have him check for that before.

I can't check it myself since the file is marked as private, so I have to
trust he looked in the correct area.
 
I just found out there is code in the file:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Check selected cell row is between the Input Top and Bottom Rows
If ActiveCell.Row >= InputRowTop And ActiveCell.Row <= InputRowBottom Then
'Evaluate each case of the selected cell column
Select Case Target.Cells.Column
'Case COSO_Column
'If MsgBox("Would you like to input?", vbOKCancel) = vbOK Then
'NamedRange = "COSO"
'UserForm1.Show
'End If
Case Controltype_Column
If MsgBox("Would you like to input?", vbOKCancel) = vbOK Then
NamedRange = "Controltype"
UserForm1.Show
End If
'Case Assertions_Column
'If MsgBox("Would you like to input??", vbOKCancel) = vbOK
Then
'NamedRange = "Assertions"
'UserForm1.Show
'End If
'Case Testmethod_Column
'If MsgBox("Would you like to input??", vbOKCancel) = vbOK
Then
'NamedRange = "Testing"
'UserForm1.Show
'End If
Case Else
End Select
End If
End Sub
 
Back
Top