Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Excel document properties insert into a cell | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |