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