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

Hi there

you could try this documents from microsoft it should tell you what
you need to know. Though if i remember when i tried the beta the
message does come up though it is now a message bar below the menu
ribbons (like the warnings that pop up below the address bar in
internet explorer) you should be able to change it there.

http://office.microsoft.com/en-us/ex...310711033.aspx

hope this helps

s

Thanks, but that's not the error msg I'm getting.

"Incidental" wrote in message
oups.com...
Hi there

you could try this documents from microsoft it should tell you what
you need to know. Though if i remember when i tried the beta the
message does come up though it is now a message bar below the menu
ribbons (like the warnings that pop up below the address bar in
internet explorer) you should be able to change it there.

http://office.microsoft.com/en-us/ex...310711033.aspx

hope this helps

s

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

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

No problem when I run this
Not sure why you have a argument in your example


Sub savefile()
filepath ="C:\Report\"
On Error Resume Next
MkDir filepath
file1 = "Report - " & Range("B5").Value & " - " & Format(Range("g4").Value, "mm-dd-yyyy")
filex = filepath & file1 & ".xlsm"
ActiveWorkbook.SaveAs Filename:=filex, FileFormat:=xlOpenXMLWorkbookMacroEnabled
End Sub

Better not use a sub name like save

--

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


"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

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
|
|

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
|
|

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
| |
| |
|
|