+ Reply to Thread
Results 1 to 4 of 4

Copy Form Control Button to new worksheet using vba

Hybrid View

  1. #1
    Registered User
    Join Date
    10-07-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Unhappy Copy Form Control Button to new worksheet using vba

    I have a worksheet that is a template to create additional worksheets, however when pressing the form button which saves the current workbook as a new filename, the form control buttons do not copy to the new workbook.

       Application.DisplayAlerts = False
        ActiveWorkbook.SaveAs Filename:=objshell.specialfolders("Desktop") & "\Mud Innovations Drilling Fluids Program\Wells\" & Range("A10") & "\" & Range("a10"), _
        FileFormat:=50
        Application.DisplayAlerts = True

    the code executes perfectly, however I need to use form control buttons, not command buttons, due to the reliability of the command button which is lacking. I would like to copy all form control buttons to the new worksheets that are created.

    Is this possible? I have searched and searched with no answers.

    The modules that I have created ARE copying over to the new workbook, i just need to copy over the Form Control button, and assign the macro if necessary to that form controlbutton.


    Thank you all in advance.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Copy Form Control Button to new worksheet using vba

    Maybe:

    Application.DisplayAlerts = False
    ActiveWorkbook.SaveAs FileName:=objshell.specialfolders("Desktop") & _
    "\Mud Innovations Drilling Fluids Program\Wells\" & _
    Range("A10") & "\" & Range("a10"), FileFormat:=52
    Application.DisplayAlerts = True
    If that doesn't work perhaps you could save it where it is and then move it
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    10-07-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Copy Form Control Button to new worksheet using vba

    That didn't work... what worked was changing the Auto Size option under format properties. Thank you for the help though.

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Copy Form Control Button to new worksheet using vba

    Hi KingKyle,

    changing the Auto Size option under format properties
    You should post that finding in "Tips & Tutorials" with a link to this thread.

+ 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. VBA Copy row into new worksheet based on Control Form Check Box
    By carlosriver24 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-06-2013, 10:42 PM
  2. [SOLVED] Macro To Open A Hidden Worksheet When Button (Form Control) Is Clicked
    By obwales in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-25-2012, 12:55 AM
  3. ActveX Control Button Not Working But Form Control Button is
    By MikeTruth in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-31-2012, 05:04 AM
  4. Copy all Entries from Form Control (not ActiveX) List Box to Worksheet
    By Saramara in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2012, 02:17 AM
  5. macro assigned to a form control button in a protected worksheet
    By lee_har in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2009, 02:29 AM

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