Mystery Cell Properties
 

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
maybe a worksheet event macro. check the code/VBA editor

--
Regards
Frank Kabel
Frankfurt, Germany

"HCK" schrieb im Newsbeitrag
...
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.




--
Regards Ron de Bruin
http://www.rondebruin.nl


"HCK" wrote in message ...
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.

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.


"Frank Kabel" wrote:

Hi
maybe a worksheet event macro. check the code/VBA editor

--
Regards
Frank Kabel
Frankfurt, Germany

"HCK" schrieb im Newsbeitrag
...
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.

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



"Frank Kabel" wrote:

Hi
maybe a worksheet event macro. check the code/VBA editor

--
Regards
Frank Kabel
Frankfurt, Germany

"HCK" schrieb im Newsbeitrag
...
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.