Tuesday, April 06, 2010

The following features cannot be saved in macro-free workbooks

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.

That was the error I was getting today when I wanted to write a macro in Excel 2007.

In order to make an Excel 2007 workbook macro enabled, you need to save the workbook as .xlsm rather than .xlsx That solves the problem of the macros not being enabled.

3 comments:

Unknown said...

Hi
thanks a lot of

My problem is solved when I follow your suggestion.

David Van der Beken said...

Simple. But great ! :)
It helps me a lot.

Nice day to you.

David Van der Beken said...

Simple. But great !
It helps me a lot.

Have a nice day :)

Step By Step Guide to resolve SQL server connection issues when connecting from R Studio

Yesterday I tried using a couple of  RevolveScaleR functions -- RxSqlServerData and RxImport.in Rstudio.  These are my learnings as part of ...