
19th May 2009, 03:26 PM
|
|
Member
|
|
Join Date: Jan 1970
Location: Western Australia
Posts: 3,403
|
|
You mayneed to activate macros,
after you have saved the excel file open it then click on "Tools" then "Options" go to the tab "Security" then look for "Macro Security" set it to "Medium"
When you are back on the sheet hit
Press Alt-F8 to bring up the macros window
Select Method260 and press run
Enter the date in YYYY/MM/DD format ie. Today will be 2009/05/19
|