Duh, I was sleeping when I reply I think <g


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jim Rech" wrote in message ...
If your macro security settings are High when you open a workbook with any
code in it, it will be disabled. Try switching to Disable with Notification
under Excel Options, Trust Center, Macro Settings. Then you'll be able to
enable the macros.

--
Jim
"DW" wrote in message
...
| Sorry, forgot to mention that original workbook is template (xlt) file.
| Below is the save code:
|
| Sub save(file1 As Variant)
| filepath = "C:\Report\"
| On Error Resume Next
| MkDir filepath
| file1 = "Report - " & Range("B5").Value & " - " &
| Format(Range("g4").Value, "mm-dd-yyyy")
| ' Report Name
| Report Date
| filex = filepath & file1 & ".xlsm"
| ActiveWorkbook.SaveAs Filename:=filex,
| FileFormat:=xlOpenXMLWorkbookMacroEnabled
| msg = "Your file has been saved at:"
| msg = msg & Chr(13) & Chr(13)
| msg = msg & filex
| MsgBox (msg)
|
| End Sub
|
| "Ron de Bruin" wrote in message
| ...
| Show us your save code
|
|
| --
|
| Regards Ron de Bruin
| http://www.rondebruin.nl/tips.htm
|
|
| "DW" wrote in message
| ...
| I just upgraded to Excel 2007. I have a simple little piece of code that
I
| run for a report.
| I saved the file as Excel Macro-Enabled Workbook.
| Now whenever I try to run the code, I get an error message:
| "The macros in this project are disabled.
| Please refer to the online help or documentation
| of the host application to determine how to
| enable macros."
|
| Of course I tried looking on microsoft's site, to no avail and Excel's
| help...still nothing.....
|
| any suggestions/help??
|
| Don
|
|