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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top