Cannot save event macro, Excel 2007

P

Prof Wonmug

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.
 
D

Don Guillett

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

Chip Pearson

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)
 
Top