to run a command in a cell
Set the Security level to low/medium in (Tools|Macro|Security). From workbook
launch VBE using short-key Alt+F11. From menu 'Insert' a module and paste the
below code. Save. Get back to Workbook.
Sub Macro1()
Range("A1") = Now
End Sub
--From ToolbarsDrawingToolbarAutoShapesBasic Shapes select any shape you
like. say ("Bevel") and place that in your worksheet.
--Right click the shapeAssign Macro and select the macro to be assigned
--Now try Button click
If this post helps click Yes
---------------
Jacob Skaria
"Steven Van Laethem" wrote:
Hello,
I want to run a command -- =Now()
in a cell.
I want it configured as a button ( in a cell) so when i press that
button/cell that automaticayly it takes the system date and tim.
Who can help me ?
|