Results 1 to 12 of 12

save sheet as macro enabled workbook using codes

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Waterbury, CT
    MS-Off Ver
    Office 365
    Posts
    1,175

    save sheet as macro enabled workbook using codes

    Hi.
    Working with a macro enabled workbook that has many sheets what would be a good code that would save Sheet1 into a new MACRO enabled workbook so that the 'Buttons' (which are linked to macros) on this specific sheet will be the only macros that will be copied to the new workbook as opposed to the rest of the macros that are found in different sheets?
    It sounds easy but I can't get it to work.

    Here is what I g=have:

    Sub SaveWorksheet()
    
    Dim ws As Worksheet:    Set ws = Sheets("Sheet1")
    
    ActiveSheet.Copy ' Copies active sheet to a new workbook
    ActiveWorkbook.SaveAs Filename:="" & Range("AD5") & Format$(Date, "YYYY-MM-DD") & " INVOICE " & Range("H5").Value & "xlsm"
    
    End Sub
    Last edited by kosherboy; 01-28-2014 at 05:28 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Set default Save-As parameter to Macro Enabled workbook
    By JimDandy in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-24-2013, 09:26 AM
  2. Macro to Save As for an Excel Macro Enabled workbook
    By hvitzthum in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-24-2013, 09:19 AM
  3. [SOLVED] VBA to save macro enabled workbook to regular workbook
    By Jiptastic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2013, 09:41 PM
  4. [SOLVED] Issue with VBA - Save as macro enabled workbook - address problem.
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-09-2012, 08:14 AM
  5. Replies: 1
    Last Post: 04-01-2011, 05:02 AM

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