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.
I don't know about Excel 2007 but in 2003 you cannot do it with a macro. An inherent feature constratint of Excel 2003.
Macro viruses use Microsoft Word and Excel's capabilities to embed code and programs into the document. When the document is opened, the macro virus is executed and infects your computer.
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.
3
Yes! you can!
macro virus
In Excel 2013 what is the name of the custom toolbar where you can attach your own macro buttons
All you need to do is edit the macro and remove the section you do not want in the macro. Excel 2007: From the Developer tab on the Menu ribbon, click on the Visual Basic icon in the Code section. See related links for a detailed tutor on how to edit an Excel macro.
In Excel 2013 what is the name of the custom toolbar where you can attach your own macro buttons
You can open the Macro dialog box by pressin Alt - F8. Then choose the macro you want and click Edit and it will bring you into the code of the macro. You do need to be careful and to be sure you know what you are doing before changing anything.
You mean a macro virus? Macro viruses infect Microsoft Excel and Word documents. When the infected document is viewed, the virus is executed.