Conversion to 2007: buttons and macros

Vette Luc

New Member
Joined
Jan 18, 2010
Messages
2
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?
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,517
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Do you have Service Pack 2 installed for Office 2007?
 

Watch MrExcel Video

Forum statistics

Threads
1,109,310
Messages
5,527,939
Members
409,793
Latest member
mavrik_stet

This Week's Hot Topics

Top