copy worksheet WITH CommandButtons within Workbook

DonJ_Austin

Guest

Posts: n/a

19th Feb 2009

I have a VBA routine that replicates the current worksheet, along with other
processing. The worksheet contains a CommandButton that does the replication
at the user's request, and it needs to be copied to the new worksheet. In
the new Worksheet, the VBA code is copied, but the CommandButton itself is
not. This critical functionality was working fine when running in XL11, but
fails in XL12.

Is this just ANOTHER reason to tell my clients not to upgrade to Office 12,
or is there some way to make it work whether the program is run in XL11 or
XL12 ?

Thanks for any help.
-dj

« Alternatives to XLSTART? | VB Error in spreadsheet with no VBA code »

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
Copy cell value from one worksheet to matching worksheet in another workbook	rech	Microsoft Excel Programming	4	29th Sep 2011 03:02 PM
Delete all commandbuttons in workbook	Steve	Microsoft Excel Programming	1	26th Mar 2008 05:34 PM
Copy Excel Worksheet to new Workbook via VBA without Links to original Workbook	JamesDMB	Microsoft Access Form Coding	0	21st Mar 2007 06:13 PM
Copy Data from Workbook into specific Worksheet in other Workbook?	kingdt	Microsoft Excel Misc	1	16th Mar 2006 06:55 PM
copy worksheet from closed workbook to active workbook using vba	=?Utf-8?B?bWFuZ28=?=	Microsoft Excel Worksheet Functions	6	9th Dec 2004 07:55 AM