Excel 2003 vba
I have a combobox I'm moving up and down the spreadsheet in Column"C"
Since I have done this my "Copy and Paste" functionality has disappeared ?
Private Sub Worksheet_SelectionChange(ByVal target As Range)
ComboBox1.Top = ActiveCell.Top
ComboBox1.Top = target.Top
'ComboBox1 value (if changed) will be stored in same row as target, column c
Set oldTarget = Cells(target.Row, 3)
ComboBox1.Height = ActiveCell.RowHeight - 6
ComboBox1.Width = 148
' get out of column Headers
If target.Rows.Count = Cells.Rows.Count Then Exit Sub
If Not Intersect(target, [A1:AU1]) Is Nothing Then
MsgBox "Not Allowed To Edit!", vbCritical, "Template Protection Error"