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.
Subscribe to:
Post Comments (Atom)
Power BI Kids competition 2026
Celebrating the next generation of data rockstars! 🚀✨ I am incredibly proud to share that we have officially wrapped up our 8-week #PowerB...
-
40 spectacular paper designs (using amazing colors & concepts) that need to look good and be informative in order to focus users’ attent...
-
Did you know that you can connect to your Power BI Desktop Model from Sql Server Management Studio (SSMS)? If not, this blog post is fo...
-
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ...
3 comments:
Hi
thanks a lot of
My problem is solved when I follow your suggestion.
Simple. But great ! :)
It helps me a lot.
Nice day to you.
Simple. But great !
It helps me a lot.
Have a nice day :)
Post a Comment