Results 1 to 8 of 8

Copying Button when copying cell

Threaded View

Einstahb Copying Button when copying... 08-14-2011, 01:49 PM
mikerickson Re: Copying Button when... 08-14-2011, 02:39 PM
Einstahb Re: Copying Button when... 08-14-2011, 06:04 PM
mikerickson Re: Copying Button when... 08-14-2011, 06:53 PM
Einstahb Re: Copying Button when... 08-14-2011, 07:26 PM
mikerickson Re: Copying Button when... 08-14-2011, 08:31 PM
Einstahb Re: Copying Button when... 08-25-2011, 03:30 PM
Einstahb Re: Copying Button when... 09-28-2011, 02:55 PM
  1. #1
    Registered User
    Join Date
    12-29-2010
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2004 for Mac
    Posts
    20

    Copying Button when copying cell

    Hi,

    I've run into an issue while building a new user form. It seems that when I copy a row that contains a button, using code through the user form, the button won't transfer once pasted into a new row. The code works perfectly in a regular macro. So, it leads me to believe that something in a private sub won't allow buttons to be copied. If you know of any work-arounds, please let me know!

    I'm using Excel 2011 for Mac.


    Here is the code I am using in the user form...

    Private Sub NewUserSubmitButton_Click()
    
    Sheets("Security").Select
    
    Range("A12:I12").Select
    Selection.EntireRow.Hidden = False
    Selection.Copy
    Cells(Rows.Count, "A").End(xlUp).Offset(1).Select
    Selection.Insert Shift:=xlDown
    
    Rows(12).EntireRow.Hidden = True
    
    Unload NewUserForm
    End Sub

    Thanks
    Last edited by Einstahb; 08-25-2011 at 03:30 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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