Hi,
Thank you for your inquiry.
After an initial test, I didn’t encounter the issue that the button lost macros. I would suggest that you download our latest commercial version (
Spire.XLS Pack(Hotfix) Version:9.6.7) to have a test, since the commercial version is more stable than the free version. If your problem still occurs after testing, please provide your Excel file and your full code to help us further look into your issue. You could send it to us via email (
support@e-iceblue.com). Thanks in advance. Besides, our Spire.XLS doesn't support operating macro at present. Sorry there is no option to assign the macro to a button.
Sincerely,
Nancy
E-iceblue support team