Cannot save event macro, Excel 2007
 

Someone on m.p.e helped me write an event macro, but when I try to
save it, I get the message:

The following features cannot be saved in a macro-free workbook:

* VB Project

To save a file with these features, click No, then choose a
macro-enabled File Type in the filetype list.

The filetype is .xlsx.

How can I get Excel to allow macros in all workbooks? I just want a
simple way to get it to stop complaining and run the macros.

I converted from Excel 2000 about a year ago. I never had any problems
with that version.

Cannot save event macro, Excel 2007
 

You must save AS a .xlsM file to have macros. AND, macros must be enabled.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Prof Wonmug" wrote in message
...
Someone on m.p.e helped me write an event macro, but when I try to
save it, I get the message:

The following features cannot be saved in a macro-free workbook:

* VB Project

To save a file with these features, click No, then choose a
macro-enabled File Type in the filetype list.

The filetype is .xlsx.

How can I get Excel to allow macros in all workbooks? I just want a
simple way to get it to stop complaining and run the macros.

I converted from Excel 2000 about a year ago. I never had any problems
with that version.

Cannot save event macro, Excel 2007
 

XLSX workbooks are designed specifically NOT to allow VBA of any sort.
That is the sole purpose of their very existence. If you need to save
any VBA with the workbook, the workbook must be saved as XLSM, XLS, or
XLSB.

It is a new feature of Excel 2007 that you can enforce a "no code"
requirement on a file. No such distinction existed in previous
versions.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Sat, 05 Sep 2009 15:43:36 -0700, Prof Wonmug wrote:

Someone on m.p.e helped me write an event macro, but when I try to
save it, I get the message:

The following features cannot be saved in a macro-free workbook:

* VB Project

To save a file with these features, click No, then choose a
macro-enabled File Type in the filetype list.

The filetype is .xlsx.

How can I get Excel to allow macros in all workbooks? I just want a
simple way to get it to stop complaining and run the macros.

I converted from Excel 2000 about a year ago. I never had any problems
with that version.