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
Bookmarks