Presumably you saved the file as .xlsm (or .xls)

Re: security: http://office.microsoft.com/en-us/ex...010096919.aspx