Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
Hello, Office 2007 specifically Excel 2007 Win XP Proof
I'm getting a msg block while in Excel Microsoft Office "The following features cannot be saved in macro free workbooks. VB Project To save a file with these features, click no, and then choose a macro - enabled file type in the file type list. To continue saving as a macro freee workbook, click yes. I have no idea what it means and can't find a reference in any book. Could someone let me to understand and how to activate macros in 2007 Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
you need to save the file as a different type, .xlsm.
XML file type Extension Workbook .xlsx Macro-enabled workbook .xlsm Template .xltx Macro-enabled template .xltm Non-XML binary workbook .xlsb Macro-enabled add-in .xlam -- Gary "BobR" wrote in message ... Hello, Office 2007 specifically Excel 2007 Win XP Proof I'm getting a msg block while in Excel Microsoft Office "The following features cannot be saved in macro free workbooks. VB Project To save a file with these features, click no, and then choose a macro - enabled file type in the file type list. To continue saving as a macro freee workbook, click yes. I have no idea what it means and can't find a reference in any book. Could someone let me to understand and how to activate macros in 2007 Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
Thanks Gary, WIll that still make the file work on 2003 and XP. I've been
saving the file as 97-2003 xls for compatability. BOB "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... you need to save the file as a different type, .xlsm. XML file type Extension Workbook .xlsx Macro-enabled workbook .xlsm Template .xltx Macro-enabled template .xltm Non-XML binary workbook .xlsb Macro-enabled add-in .xlam -- Gary "BobR" wrote in message ... Hello, Office 2007 specifically Excel 2007 Win XP Proof I'm getting a msg block while in Excel Microsoft Office "The following features cannot be saved in macro free workbooks. VB Project To save a file with these features, click no, and then choose a macro - enabled file type in the file type list. To continue saving as a macro freee workbook, click yes. I have no idea what it means and can't find a reference in any book. Could someone let me to understand and how to activate macros in 2007 Thanks in advance |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
If you've been saving as xls, I don't think you should be getting that
message. I get it when I save as .xlsx, but not .xls or .xlsm. Darren On Sat, 07 Apr 2007 07:00:46 +0100, BobR wrote: Thanks Gary, WIll that still make the file work on 2003 and XP. I've been saving the file as 97-2003 xls for compatability. BOB "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... you need to save the file as a different type, .xlsm. XML file type Extension Workbook .xlsx Macro-enabled workbook .xlsm Template .xltx Macro-enabled template .xltm Non-XML binary workbook .xlsb Macro-enabled add-in .xlam -- Gary "BobR" wrote in message ... Hello, Office 2007 specifically Excel 2007 Win XP Proof I'm getting a msg block while in Excel Microsoft Office "The following features cannot be saved in macro free workbooks. VB Project To save a file with these features, click no, and then choose a macro - enabled file type in the file type list. To continue saving as a macro freee workbook, click yes. I have no idea what it means and can't find a reference in any book. Could someone let me to understand and how to activate macros in 2007 Thanks in advance -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
if you save it as an xls, you should not get that message, but you would lose
any of the new features in 2007, like some of the conditional formatting options and the expanded rows and columns. if you try saving as an xlsx, the 2007 default, you will get that message if you have any macros. -- Gary "BobR" wrote in message ... Thanks Gary, WIll that still make the file work on 2003 and XP. I've been saving the file as 97-2003 xls for compatability. BOB "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... you need to save the file as a different type, .xlsm. XML file type Extension Workbook .xlsx Macro-enabled workbook .xlsm Template .xltx Macro-enabled template .xltm Non-XML binary workbook .xlsb Macro-enabled add-in .xlam -- Gary "BobR" wrote in message ... Hello, Office 2007 specifically Excel 2007 Win XP Proof I'm getting a msg block while in Excel Microsoft Office "The following features cannot be saved in macro free workbooks. VB Project To save a file with these features, click no, and then choose a macro - enabled file type in the file type list. To continue saving as a macro freee workbook, click yes. I have no idea what it means and can't find a reference in any book. Could someone let me to understand and how to activate macros in 2007 Thanks in advance |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
Unfortunately I have to save as xls, and that's all I've been doing it with
because of other computers that I am working with. I get this message on the 97-2003 saving of the xls worksheet and I've got a lot of macros in it. I'll have to do some more homework, thanks so much guys and girls.. BOB "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... if you save it as an xls, you should not get that message, but you would lose any of the new features in 2007, like some of the conditional formatting options and the expanded rows and columns. if you try saving as an xlsx, the 2007 default, you will get that message if you have any macros. -- Gary "BobR" wrote in message ... Thanks Gary, WIll that still make the file work on 2003 and XP. I've been saving the file as 97-2003 xls for compatability. BOB "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... you need to save the file as a different type, .xlsm. XML file type Extension Workbook .xlsx Macro-enabled workbook .xlsm Template .xltx Macro-enabled template .xltm Non-XML binary workbook .xlsb Macro-enabled add-in .xlam -- Gary "BobR" wrote in message ... Hello, Office 2007 specifically Excel 2007 Win XP Proof I'm getting a msg block while in Excel Microsoft Office "The following features cannot be saved in macro free workbooks. VB Project To save a file with these features, click no, and then choose a macro - enabled file type in the file type list. To continue saving as a macro freee workbook, click yes. I have no idea what it means and can't find a reference in any book. Could someone let me to understand and how to activate macros in 2007 Thanks in advance |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
I'll have to do some more homework
I agree<g. Echoing what Darren and Gary said, I've saved workbooks plenty of times in the xls, 97-03, format with no macro warning. -- Jim "BobR" wrote in message .. . Unfortunately I have to save as xls, and that's all I've been doing it with because of other computers that I am working with. I get this message on the 97-2003 saving of the xls worksheet and I've got a lot of macros in it. I'll have to do some more homework, thanks so much guys and girls.. BOB "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... if you save it as an xls, you should not get that message, but you would lose any of the new features in 2007, like some of the conditional formatting options and the expanded rows and columns. if you try saving as an xlsx, the 2007 default, you will get that message if you have any macros. -- Gary "BobR" wrote in message ... Thanks Gary, WIll that still make the file work on 2003 and XP. I've been saving the file as 97-2003 xls for compatability. BOB "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... you need to save the file as a different type, .xlsm. XML file type Extension Workbook .xlsx Macro-enabled workbook .xlsm Template .xltx Macro-enabled template .xltm Non-XML binary workbook .xlsb Macro-enabled add-in .xlam -- Gary "BobR" wrote in message ... Hello, Office 2007 specifically Excel 2007 Win XP Proof I'm getting a msg block while in Excel Microsoft Office "The following features cannot be saved in macro free workbooks. VB Project To save a file with these features, click no, and then choose a macro - enabled file type in the file type list. To continue saving as a macro freee workbook, click yes. I have no idea what it means and can't find a reference in any book. Could someone let me to understand and how to activate macros in 2007 Thanks in advance |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007Warning, "The following fetures cannot be saved in a
Bob,
If you're still having this issue, go to the office button at the upper left corner of the Excel program window. Click on the "Excel Options" button at the bottom of that pop-up. It will then open another window. Look for "Trust Center" at the left side. Click on that, and work your way through that. You'll then look for "Trust Center Settings." Click on that, and you'll find where you can disable, or enable your macros to work in all, or only certain workbooks. This should resolve your problems. "Jim Rech" wrote: I'll have to do some more homework I agree<g. Echoing what Darren and Gary said, I've saved workbooks plenty of times in the xls, 97-03, format with no macro warning. -- Jim "BobR" wrote in message .. . Unfortunately I have to save as xls, and that's all I've been doing it with because of other computers that I am working with. I get this message on the 97-2003 saving of the xls worksheet and I've got a lot of macros in it. I'll have to do some more homework, thanks so much guys and girls.. BOB "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... if you save it as an xls, you should not get that message, but you would lose any of the new features in 2007, like some of the conditional formatting options and the expanded rows and columns. if you try saving as an xlsx, the 2007 default, you will get that message if you have any macros. -- Gary "BobR" wrote in message ... Thanks Gary, WIll that still make the file work on 2003 and XP. I've been saving the file as 97-2003 xls for compatability. BOB "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... you need to save the file as a different type, .xlsm. XML file type Extension Workbook .xlsx Macro-enabled workbook .xlsm Template .xltx Macro-enabled template .xltm Non-XML binary workbook .xlsb Macro-enabled add-in .xlam -- Gary "BobR" wrote in message ... Hello, Office 2007 specifically Excel 2007 Win XP Proof I'm getting a msg block while in Excel Microsoft Office "The following features cannot be saved in macro free workbooks. VB Project To save a file with these features, click no, and then choose a macro - enabled file type in the file type list. To continue saving as a macro freee workbook, click yes. I have no idea what it means and can't find a reference in any book. Could someone let me to understand and how to activate macros in 2007 Thanks in advance |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reply to Steve
Hi Steve,
Thanks, Your suggestion worked for me. Regards pavan SteveDB wrote: Bob,If you're still having this issue, go to the office button at the upper 05-Jun-07 Bob, If you're still having this issue, go to the office button at the upper left corner of the Excel program window. Click on the "Excel Options" button at the bottom of that pop-up. It will then open another window. Look for "Trust Center" at the left side. Click on that, and work your way through that. You'll then look for "Trust Center Settings." Click on that, and you'll find where you can disable, or enable your macros to work in all, or only certain workbooks. This should resolve your problems. "Jim Rech" wrote: Previous Posts In This Thread: On Saturday, April 07, 2007 1:01 AM BobR wrote: Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook: Hello, Office 2007 specifically Excel 2007 Win XP Proof I'm getting a msg block while in Excel Microsoft Office "The following features cannot be saved in macro free workbooks. VB Project To save a file with these features, click no, and then choose a macro - enabled file type in the file type list. To continue saving as a macro freee workbook, click yes. I have no idea what it means and can't find a reference in any book. Could someone let me to understand and how to activate macros in 2007 Thanks in advance On Saturday, April 07, 2007 1:22 AM Gary Keramidas wrote: you need to save the file as a different type, .xlsm. you need to save the file as a different type, .xlsm. XML file type Extension Workbook .xlsx Macro-enabled workbook .xlsm Template .xltx Macro-enabled template .xltm Non-XML binary workbook .xlsb Macro-enabled add-in .xlam -- Gary "BobR" wrote in message ... On Saturday, April 07, 2007 2:00 AM BobR wrote: Thanks Gary, WIll that still make the file work on 2003 and XP. Thanks Gary, WIll that still make the file work on 2003 and XP. I have been saving the file as 97-2003 xls for compatability. BOB On Saturday, April 07, 2007 2:29 AM Darren Hill wrote: If you've been saving as xls, I don't think you should be getting that If you've been saving as xls, I don't think you should be getting that message. I get it when I save as .xlsx, but not .xls or .xlsm. Darren On Sat, 07 Apr 2007 07:00:46 +0100, BobR wrote: -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ On Saturday, April 07, 2007 2:43 AM Gary Keramidas wrote: if you save it as an xls, you should not get that message, but you would lose if you save it as an xls, you should not get that message, but you would lose any of the new features in 2007, like some of the conditional formatting options and the expanded rows and columns. if you try saving as an xlsx, the 2007 default, you will get that message if you have any macros. -- Gary "BobR" wrote in message ... On Saturday, April 07, 2007 6:38 AM BobR wrote: Unfortunately I have to save as xls, and that's all I've been doing it with Unfortunately I have to save as xls, and that's all I've been doing it with because of other computers that I am working with. I get this message on the 97-2003 saving of the xls worksheet and I've got a lot of macros in it. I'll have to do some more homework, thanks so much guys and girls.. BOB "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... On Saturday, April 07, 2007 1:30 PM Jim Rech wrote: I agree<g. I agree<g. Echoing what Darren and Gary said, I have saved workbooks plenty of times in the xls, 97-03, format with no macro warning. -- Jim On Tuesday, June 05, 2007 12:26 PM SteveDB wrote: Bob,If you're still having this issue, go to the office button at the upper Bob, If you're still having this issue, go to the office button at the upper left corner of the Excel program window. Click on the "Excel Options" button at the bottom of that pop-up. It will then open another window. Look for "Trust Center" at the left side. Click on that, and work your way through that. You'll then look for "Trust Center Settings." Click on that, and you'll find where you can disable, or enable your macros to work in all, or only certain workbooks. This should resolve your problems. "Jim Rech" wrote: Submitted via EggHeadCafe - Software Developer Portal of Choice WPF Customized Find Control for FlowDocuments http://www.eggheadcafe.com/tutorials...ind-contr.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display "macro-free workbooks - VB project message" on closing Exc | Excel Discussion (Misc queries) | |||
Is there a "last saved on date/user" macro/function for Excel 2003 | Excel Discussion (Misc queries) | |||
"No more fonts may be applied in this workbook." when saved. Why? | Excel Discussion (Misc queries) | |||
Free books on Charting, Basics, Data Management, Functions; Free Add-In "Excel Usability Enhancer" | Excel Programming | |||
Changes are saved to workbook even though I chose "No" when selecting close | Excel Programming |