converting active x buttons to Excel 2007

  • Thread starter Office Productivity Consultant
  • Start date
O

Office Productivity Consultant

I am helping a client switch from Office 97 to 2007. They have some Active X
buttons in Excel worksheets that have vba code behind them. When we convert
the files to xlsm files, the code stays but the Active X buttons are renamed
to command button 1, command button 2, etc. Is there a way to have them
retain the names of the active x buttons so the code will run? Otherwise, we
have to change the name property of all buttons in these files
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top