I have a workbook with several buttons that refer to VBA code. The workbook was developped in XLS 2003.
In XLS 2007, when converting to XLS 2007 or saving under XLSM format the link between some buttons and the correstponding macros are lost.
I don't see any logic between the links that did not disappear and the ones that did disappear.
* The links to subroutines that kept the name CommandButtonx_Click() (x= the original number) stayed.
* Some names of subroutines were changed and the link was ok.
* Some names were changed and the link was lost.
A) Does someone has any experience with this?
B) Does anyone has a solution for this?
In XLS 2007, when converting to XLS 2007 or saving under XLSM format the link between some buttons and the correstponding macros are lost.
I don't see any logic between the links that did not disappear and the ones that did disappear.
* The links to subroutines that kept the name CommandButtonx_Click() (x= the original number) stayed.
* Some names of subroutines were changed and the link was ok.
* Some names were changed and the link was lost.
A) Does someone has any experience with this?
B) Does anyone has a solution for this?
