I sleep through my share too, Ron. Good thing Dave and Tom are here to set
things right<g>.
--
Jim
| Duh, I was sleeping when I reply I think <g>
|
|
| --
|
| Regards Ron de Bruin
|
http://www.rondebruin.nl/tips.htm
|
|
| > 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
| > | > | 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
| > |
| > | | > | > Show us your save code
| > | >
| > | >
| > | > --
| > | >
| > | > Regards Ron de Bruin
| > | >
http://www.rondebruin.nl/tips.htm
| > | >
| > | >
| > | > | > | >>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
| > |
| > |
| >
| >
