Unable to record Excel 2010 macro
Solved
mago92
Posted messages
11
Status
Member
-
to -
to -
Hello everyone,
I created a file in Excel 2010 with a VBA button that automatically formats a pivot table. I initially saved my macro in my personal macros. After verifying that my macro worked well, I decided to assign my macro to the Excel workbook since several of my colleagues will use this file. No problem creating a new module in the workbook, but when saving my file, here is the error message that appears:
“The following features cannot be saved in macro-free workbooks: VB project.”
I tried creating other macros in other workbooks, but this error message keeps coming up.
I never encountered this problem in Excel 2003.
Does anyone have a solution?
For now, I've saved my macro on my colleagues' computers while waiting to find a better solution!
Thank you for your valuable help.
Mago.
I created a file in Excel 2010 with a VBA button that automatically formats a pivot table. I initially saved my macro in my personal macros. After verifying that my macro worked well, I decided to assign my macro to the Excel workbook since several of my colleagues will use this file. No problem creating a new module in the workbook, but when saving my file, here is the error message that appears:
“The following features cannot be saved in macro-free workbooks: VB project.”
I tried creating other macros in other workbooks, but this error message keeps coming up.
I never encountered this problem in Excel 2003.
Does anyone have a solution?
For now, I've saved my macro on my colleagues' computers while waiting to find a better solution!
Thank you for your valuable help.
Mago.
