Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    342
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Paste to new sheet (2000-SR1)

    This should be a snack...
    I have text with check boxes on a sheet. I have recorded a macro to copy the 'Main' sheet, insert a new sheet and paste the contents into the new sheet.
    When recording the macro, the process works fine, I have new check boxes on my new sheet relating to cells on my new sheet. Bewty.

    When I play the macro back - ooooh boy - the check boxes are pasted, without 3D shading, then, over the top of my sheet a *picture* of the main sheet.
    How can I resolve this?
    Here is the code Excel recorded:

    Sheets("Main").Select
    Selection.Copy
    Sheets.Add
    ActiveSheet.CheckBoxes.Add(114, 61.5, 24, 17.25).Select
    ActiveSheet.CheckBoxes.Add(180, 61.5, 12, 17.25).Select
    ActiveSheet.CheckBoxes.Add(220.5, 61.5, 19.5, 17.25).Select
    ActiveSheet.Paste

    Thanks for any help offered!

  2. #2
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    342
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paste to new sheet (2000-SR1)

    OK, after much toying around I've resolved the issue - the problem was with the "ActiveSheet.Checkboxes.Add....." rows. Once I commented them out it worked as it should. Don't know why, but here's a solution if anyone else has problems with objects or check boxes.
    Thanks for looking!

Posting Permissions

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