J
Joe HM
Hello -
I was wondering if there is a way in an Excel macro where I can catch
the paste event to make sure the user only copies/pastes the values of
a field and not the format?
I have some conditional formatting and if the user copies a certain
cell, things get screwed up. Is there also a way to block a cut/paste?
I tried relative formatting but for some reason things get screwed up
when I run a macro that creates the relative formatting:
With lTPSheet.Range("B" & lSelection.Row & ":E" & lSelection.Row)
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:="=$D" &
lSelection.Row & "=""X"""
.FormatConditions(1).Font.ColorIndex = 2
.FormatConditions(1).Interior.ColorIndex = 3
End With
The Formula1:="=$D" & lSelection.Row & "=""X""" does NOT set the
correct row for some reason (usually off by 3) if it is a relative
reference rather than absolute ($).
Very strange unless I'm really missing something ...
Thanks!
Joe
I was wondering if there is a way in an Excel macro where I can catch
the paste event to make sure the user only copies/pastes the values of
a field and not the format?
I have some conditional formatting and if the user copies a certain
cell, things get screwed up. Is there also a way to block a cut/paste?
I tried relative formatting but for some reason things get screwed up
when I run a macro that creates the relative formatting:
With lTPSheet.Range("B" & lSelection.Row & ":E" & lSelection.Row)
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:="=$D" &
lSelection.Row & "=""X"""
.FormatConditions(1).Font.ColorIndex = 2
.FormatConditions(1).Interior.ColorIndex = 3
End With
The Formula1:="=$D" & lSelection.Row & "=""X""" does NOT set the
correct row for some reason (usually off by 3) if it is a relative
reference rather than absolute ($).
Very strange unless I'm really missing something ...
Thanks!
Joe