converting active x buttons to Excel 2007

Office Productivity Consultant

Guest

Posts: n/a

22nd Dec 2008

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
--
Judy L

« Paste Special - Values code | Ctrl+F Find by value »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting MS query from Excel 2003 to Excel 2007	Dale	Microsoft Excel Programming	1	13th Mar 2010 04:53 AM
ActiveX buttons lost pictures after converting to a 2007 file form	MichaelV	Microsoft Excel Crashes	0	2nd Jun 2009 09:17 PM
Converting Excel 2007 sheet back down to Excel 2003	RLN	Microsoft Excel Programming	1	30th Apr 2009 08:02 PM
CONVERTING OFFICE 97-2003 EXCEL FILES TO 2007 EXCEL	=?Utf-8?B?TWFyeSBBbm4=?=	Microsoft Excel Misc	5	8th Aug 2007 10:06 PM
active x radio buttons in excel	=?Utf-8?B?QW5uYQ==?=	Microsoft Excel Programming	4	16th Jun 2005 01:42 AM