Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This code is in my data worksheet whenever any data is copied to other sheets
the on key apps. go with it. Can I stop the on key apps. from being active on sheets copied to? Ckeck up is a procedure that checks for row data completed. I thought that as a private sub it would only be active on this sheet Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range On Error GoTo errhandler Application.EnableEvents = False If Target.Column = 12 And Target.Value (" ") Then _ Call Announcer(Target) If Target.Column = 8 And Target.Value 1 And IsNumeric(Target.Value) Then _ Call CopyMailE(Target) If Target.Column = 11 And Target.Value 10 And IsNumeric(Target.Value) Then _ Call CopyDonors(Target) If Target.Column = 11 And Target.Value 10 And IsNumeric(Target.Value) Then _ Call CopyMailD(Target) errhandler: Application.EnableEvents = True Application.OnKey "{RETURN}", "checkUp" Application.OnKey "{DOWN}", "checkUp" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i stop my arrow keys from scrolling? | Excel Discussion (Misc queries) | |||
Macro Shortcut Key Conflicts with Application Shortcut Keys | Excel Programming | |||
Macro Shortcut Key Conflicts with Application Shortcut Keys | Excel Programming | |||
Application.OnKey syntax for + and - keys | Excel Programming | |||
what is the keys to stop recording, i cant press it when making a. | Excel Discussion (Misc queries) |