Re: Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
- From: "Gary Keramidas" <GKeramidasATmsn.com>
- Date: Sat, 7 Apr 2007 02:43:54 -0400
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" <rjr1040@xxxxxxxxxxxxx> wrote in message
news:ErGRh.1064$qB4.731@xxxxxxxxxxxxxxxxxxxxxxxxx
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
news:udKszSNeHHA.3996@xxxxxxxxxxxxxxxxxxxxxxx
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" <rjr1040@xxxxxxxxxxxxx> wrote in message
news:kAFRh.110$df1.35@xxxxxxxxxxxxxxxxxxxxxxxxx
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
.
- Follow-Ups:
- References:
- Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
- From: BobR
- Re: Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
- From: Gary Keramidas
- Re: Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
- From: BobR
- Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
- Prev by Date: Re: Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
- Next by Date: show daily sales as a percentage of monthly sales target
- Previous by thread: Re: Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
- Next by thread: Re: Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
- Index(es):
Relevant Pages
|