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)
Navigating the Data Science Seas: A Journey with Microsoft Fabric
Data science is a vast and exciting field, brimming with the potential to unlock valuable insights. But like any seafaring voyage, navigatin...
-
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ... -
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des... -
Today I was trying Node.js to connect to SQL Server, the connection to the sql server failed with the below error. name: 'ConnectionE...
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