+ Reply to Thread
Results 1 to 3 of 3

Copying ActiveX controls and their associate code across to multiple worksheets

  1. #1
    Registered User
    Join Date
    10-27-2014
    Location
    UK
    MS-Off Ver
    Office 10
    Posts
    25

    Copying ActiveX controls and their associate code across to multiple worksheets

    Hi,

    Is there an easy way to copy the entirety of a worksheet (cell content, ActiveX controls in the worksheet, and the macro code associated with that sheet) across to many other worksheets?
    I mean manually, not by writing VBA to do it.
    [A Cntl A -based copy and paste just seems to copy the cell content - not the ActiveX controls or it's associated handling code].
    The ActiveX handling code is all in the individual worksheet module (well, it isn't, but the stub handling code is, and then it re-directs the handling to other code located in a shared (normal) module.

    Thanks in anticipation for your advice,
    Cheers,

    MathUKTeacher

  2. #2
    Registered User
    Join Date
    10-27-2014
    Location
    UK
    MS-Off Ver
    Office 10
    Posts
    25

    Re: Copying ActiveX controls and their associate code across to multiple worksheets

    I really need some help with this.
    Is it really not possible?

    Thanks, and sorry for bumping.

    MathUKTeacher

  3. #3
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Copying ActiveX controls and their associate code across to multiple worksheets

    Hold down "Ctrl" , Select the sheet tab with the mouse, and drag to right to create a complete copy of the first sheet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Conditional Formatting for Multiple ActiveX Controls
    By katkth7533 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-11-2014, 10:36 AM
  2. [SOLVED] Can't edit code in in ActiveX controls
    By bibu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2014, 01:43 PM
  3. copying the datas along with the activex controls and pasting in another worksheet
    By share knowledge in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-14-2011, 01:30 PM
  4. Form controls vs. ActiveX controls
    By wmorrison49 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2008, 10:59 AM
  5. ActiveX Controls vs Form Controls
    By Alex in forum Excel General
    Replies: 1
    Last Post: 01-11-2006, 04:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1