Re: 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" <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




.



Relevant Pages

  • Re: Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
    ... Macro-enabled workbook .xlsm ... "The following features cannot be saved in macro free workbooks. ... enabled file type in the file type list. ...
    (microsoft.public.excel.programming)
  • RE: Web queries crash excel
    ... XLS file type which limits the number of rows and columns. ... All the tabs are now selected. ... Select Make a copy and then on the pull down sleect new workbook. ... This method will force excel to copy the data and eleiminatre any errors ...
    (microsoft.public.excel.misc)
  • RE: Web queries crash excel
    ... XLS file type which limits the number of rows and columns. ... All the tabs are now selected. ... Select Make a copy and then on the pull down sleect new workbook. ... This method will force excel to copy the data and eleiminatre any errors ...
    (microsoft.public.excel.misc)
  • Re: Excel 2007Warning, "The following fetures cannot be saved in a macro-free workbook:
    ... I get this message on the 97-2003 saving of the xls worksheet and I've got a lot of macros in it. ... Macro-enabled workbook .xlsm ... "The following features cannot be saved in macro free workbooks. ... To save a file with these features, click no, and then choose a macro - enabled file type in the file type list. ...
    (microsoft.public.excel.programming)
  • Re: 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. ... Macro-enabled workbook .xlsm ... enabled file type in the file type list. ...
    (microsoft.public.excel.programming)

Loading