Running a macro on action
To access the events that are generated on a sheet do this...
Right Click the tab of the sheet - Select View Code
Just above the code window you will see the word general
Change General to Worksheet
Just to the right of Worksheet is a drop down list of all of the events that
you can make your code respond to. Note that when you select the event a code
procedure is created for you automatically... Easy as that. Some of the
procedures will have arguments like Target. Target is the cell you just
changed or selected or...
HTH
"Andrew" wrote:
Hi,
This is probably a simple one but I just cant find the answer. How does one
kick off a macro by a specific cell being altered (eg data keyed into it,
change of font etc)
--
Andrew
|