Jim Rech posted a registry tweak ....
See Ron de Bruin's page....

(Copy and paste is my friend!)

Jim Rech wrote:

I sleep through my share too, Ron. Good thing Dave and Tom are here to set
things right<g.

--
Jim
"Ron de Bruin" wrote in message
...
| 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
| |
| |
|
|

--

Dave Peterson