Free Support Forum - aspose.com

Button loosing assignment to macro

Hi,

in the Excel file “Input” attached, there are two buttons on sheet “Vergleich” called “Nur Differenz ab 1h einblenden” and “Alles einblenden”.
There are two macros assigned to these buttons which are working.
After opening the file with Aspose.Cells and changing/adding some data on other sheets of the excel (no changes on sheet “Vergleich”!) and saving the file under a new file name (“Output”), the two buttons are not working anymore - they lost the macro assignment and are just “normal” images (I allowed the execution of macros…).
Also see screenshots…
When re-assigning the macros (which are still there), the buttons are working again.


Currently we are using version 6.0.1.2 of Aspose.Cells.

Sincerely,
Matthias Wohlmann
Hi,

Please try your the latest version/fix:Aspose.Cells for .NET (Latest Version) I have tested with it and it works fine. The macros are kept attached with the buttons after re-saving your template file.

Thank you.

Hello,

yes, that solved the problem.

Thank you very much!

matthias

Hi,

Thanks for your feedback.

It’s good to know your issue is resolved with the Aspose.Cells for .NET fix.

Please note, macros are not lost if you save your xlsm file into xlsm file. Besides, we have now supported to preserve macros in cross formats conversion.

i.e

Xlsm --> Xls preserves macros
Xls --> Xlsm preserve macros.

Please download and try the latest version:
Aspose.Cells for .NET (Latest Version) .
Let us know if you face any issue.