+ Reply to Thread
Results 1 to 8 of 8

copying the datas along with the activex controls and pasting in another worksheet

  1. #1
    Registered User
    Join Date
    08-02-2008
    Location
    India
    Posts
    88

    copying the datas along with the activex controls and pasting in another worksheet

    Hello Experts

    I know this is simple but not getting a clue on how to do it.

    I have a worksheet "Format" where a template is saved. I have used active x controls in this sheet (Submit, Resubmit, Update) and these buttons has got a code also.

    When i try copy pasting all these info in to another sheet, only the cells and the form controls getting copied not the activex controls)

    how can i go about with this?

    Thank u

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,369

    Re: copying the datas along with the activex controls and pasting in another workshee

    Is the code behind the worksheet or in a module?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    08-02-2008
    Location
    India
    Posts
    88

    Re: copying the datas along with the activex controls and pasting in another workshee

    Hi Marvin
    yes, it is in the module. It is not visible in the macro list.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,369

    Re: copying the datas along with the activex controls and pasting in another workshee

    So you copy a worksheet, how exactly do you copy it?

    Can you supply a short example? Do you have acitve x controls on the sheet itself or only on Userforms that come up?

    I need more info and to try this to discover what it should do and what you think it should do.

    Also what version of XL are you using? Please edit your profile to display this.

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,369

    Re: copying the datas along with the activex controls and pasting in another workshee

    I've put an active x command button on sheet 1 and code behind the button.

    I then copy the entire sheet and pasted it to another sheet. The control shape is copied to the new sheet but not the code.

    My guess is this is the way it works.

  6. #6
    Registered User
    Join Date
    08-02-2008
    Location
    India
    Posts
    88

    Re: copying the datas along with the activex controls and pasting in another workshee

    ok. I am using Excel 2007

    here is the atatchement. When i copy paste the info to sheet 2 only cells are getting pasted not the activex button.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    08-02-2008
    Location
    India
    Posts
    88

    Re: copying the datas along with the activex controls and pasting in another workshee

    u used activex or form controls?

    if i use form controls it is getting copy pasted, but not the active x .. also i dont need the entire sheet to be pasted just few rows along with the button.

  8. #8
    Registered User
    Join Date
    08-02-2008
    Location
    India
    Posts
    88

    Re: copying the datas along with the activex controls and pasting in another workshee

    any update on this?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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