Help with Enable Macro Error Msg (Excel 2007)
 

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

Help with Enable Macro Error Msg (Excel 2007)
 

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

Help with Enable Macro Error Msg (Excel 2007)
 

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

Help with Enable Macro Error Msg (Excel 2007)
 

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

Help with Enable Macro Error Msg (Excel 2007)
 

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

Help with Enable Macro Error Msg (Excel 2007)
 

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

Help with Enable Macro Error Msg (Excel 2007)
 

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

Help with Enable Macro Error Msg (Excel 2007)
 

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

Help with Enable Macro Error Msg (Excel 2007)
 

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

Help with Enable Macro Error Msg (Excel 2007)
 

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

I think Dave and tom are robots Jim.
They are to smart to be human <vbg



--

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


"Jim Rech" wrote in message ...
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
| |
| |
|
|

Help with Enable Macro Error Msg (Excel 2007)
 

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