Hi,

I tried the "Application.EnableEvents" method, but it gave me the erro
1004 "select method of range class failed"

let me try explaining it again:

there is this first macro(1st) which doesnot let anyone select th
cells in the area b2:c2001 and there is another macro(2nd) which want
to copy the contents in the same area and paste the values (past
specialvalues) in that area, but the 1st one doesnt allow .........

i hope i have explained the problem clearly now.....

thanks again for replying!!

--
Message posted from http://www.ExcelForum.com

Oops.... sorry... i forgot to metion this:

I have this code written which doesnt let the user to select the cell
(to prevent accidental deletion):

1st macro:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, Me.Range("b2:c2001")) Is Nothing Then Exit Sub
Me.Cells(Target.Row, "D").Select

End Sub


Now the problem is that i want a macro which will just copy the b and
columns and paste the values to the same columns, the macro is preet
simple, the problem is that because of the earlier macro, i canno
select the columns.....

2nd Macro:
Sub Macro()

Range("B1:C1").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Range("B1").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:
_
False, Transpose:=False
End Sub


is there a way where i can turn the fist macro OFF when the secon
macro runs???

thanks for any help!!

--
Message posted from http://www.ExcelForum.com