Activate macro1
Not exactly, but you can trigger a macro any time you go to cell S8 (either
via mouse or keyboard) using the Worksheet_SelectionChange event.
Put the following code in the sheet module:
Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$S$8" Then Macro1
End Sub
Macro1 should be in a standard module and not designated as Private.
--
Vasant
"IRMA MENDOSA" wrote in message
...
I Have this template the fills up a deposit slip and the only thing that i
have to do is fill up the amount in cell S7 and then press enter to go to
cell S8
Is there a way to activate macro1
when i hit enter to go to next cell wich is S8
Thanks in advance
|