+ Reply to Thread
Results 1 to 5 of 5

Macro copies a group of cells as a picture rather than regular cells.

  1. #1
    Registered User
    Join Date
    12-11-2014
    Location
    Hamburg, PA
    MS-Off Ver
    2010
    Posts
    3

    Macro copies a group of cells as a picture rather than regular cells.

    I have a form that I've created a macro that inserts a 4 new columns from A to D selects, copies, a form and inserts it into the new columns. When I do the process manually I have no problem. When I run the macro, it pastes it as a picture and I can't enter data into it (I'm using special paste "paste source column widths"). After much trial and error I figured out that the macro will work properly if I remove all of the text box and the buttons. I can live with out the text box, but I need the button because eventually I need to link other macros to the buttons. Any ideas?

  2. #2
    Forum Contributor
    Join Date
    04-14-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    198

    Re: Macro copies a group of cells as a picture rather than regular cells.

    Can you attach your file so we can see the issue hands on... then I or someone else can help you fix it much faster

  3. #3
    Registered User
    Join Date
    12-11-2014
    Location
    Hamburg, PA
    MS-Off Ver
    2010
    Posts
    3

    Re: Macro copies a group of cells as a picture rather than regular cells.

    Good Idea. I've attached the spreadsheet. Look at the sheet "level 1". Thanks for your help!
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    04-14-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    198

    Re: Macro copies a group of cells as a picture rather than regular cells.

    Hopefully someone else will understand what you are working with I do not seem to see what you are trying to accomplish with your macro

  5. #5
    Registered User
    Join Date
    12-11-2014
    Location
    Hamburg, PA
    MS-Off Ver
    2010
    Posts
    3

    Re: Macro copies a group of cells as a picture rather than regular cells.

    Here, I've cleaned up the attachment so that if you go to my macros there is only one. Looking at sheet Level 1 columns e through h is my orignal form. a-d is what I created when I made my macro. If you go to the macro button, and run macro8, it will put down a third form that looks like the orignal except I can't enter info, it appears to be a picture. Now if I repeated the process exactly as shown, only build the forms without the option buttons, everything works perfectly. I'm not sure what the problem is or how to fix it. I hope that makes a little more sense. Whether or not you are able to help me, I appreciate that you took the time to give it a try. Aaron
    Attached Files Attached Files

+ 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. Macro that copies certain cells only into a new workbook
    By BDarden in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2014, 11:27 AM
  2. Almost done, Macro grabs excel cells copies to word
    By DadaaP in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 05-31-2013, 02:08 AM
  3. Replies: 0
    Last Post: 02-04-2013, 03:25 PM
  4. macro that puts a formula in a group of cells then goes and values those cells
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-31-2007, 02:00 AM
  5. A macro that copies and pastes autofiltered cells will fail.
    By Mafunzalo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2005, 01:05 PM

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