Use the control Worksheet_Change. See related links for a sample macro that will trigger a macro when the cell changes. Modify, as needed, to fit your specific situation.
Record in excel is used to record a macro. If you press record and perform any action on excel, all these actions are recorded and stored in a macro. You can run this macro again to preform the same task.
I don't know about Excel 2007 but in 2003 you cannot do it with a macro. An inherent feature constratint of Excel 2003.
A Macro is a small program which is typed into a Macro File. In Excel click Help on the toolbar then type "Macro". This will tell you what they are, what they do and how to create them. They are very useful. You can also on the toolbar click on "Tools" then "Macros" to see what is there.
The following is a record macro copied into the workbook open section of the workbooks properties. Enters date in a1 Private Sub Workbook_Open() Range("a1").Activate ActiveCell.FormulaR1C1 = Now() Selection.NumberFormat = "dd/mm/yyyy;@" End Sub The macro run's it's self when the file opens
End Sub.
Macro virus
Macro is feature in MS Excel software which records all the steps and all the steps can be repeated whenever a same task is required to be performed. It helps in reduction of time in performing monotonous task. Macro is available in Tools menu.
macro virus
3
Macro viruses
Yes! you can!