Macro assigned for an Icon problem
Posted by Eli Weiss on November 21, 2001 5:34 AM
I have made a customized ICON on the toolbar and assigned a simple macro to it:
ActiveCell.FormulaR1C1 = "=TODAY()"
This macro puts DATE into the current cell whenever I press the ICON
The problem is that I must keep available the original workbook that had the macro
How can I assign the macro to the ICON so that it would not need to open the original workbook?
I hope that I made myself clear