+ Reply to Thread
Results 1 to 3 of 3

Adding Code to SaveAs Workbooks

  1. #1
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    500

    Adding Code to SaveAs Workbooks

    Greetings,
    I am using the following code to perform a SaveAs. All works good, but I am needing to insert a "Call" macro code for the workbook being saved as. However, this code only effects the current workbook not the one being created. The macro needing to be applied to the new workbook is "set_Master_Font_to_blk"
    Please Login or Register  to view this content.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Adding Code to SaveAs Workbooks

    Hello again!

    Could we see the "set_Master_Font_to_blk" code?

    And if at all possible, perhaps a desensitized version of the workbooks?

    Always easier to help if we can see it in context.

    BSB

  3. #3
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    500

    Re: Adding Code to SaveAs Workbooks

    BSB
    Here is the code for "set_Master_Font_to_blk". Unfortunately I am unable to provide a desensitized version.
    Please Login or Register  to view this content.

+ 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. Adding Proctect WorkSheet to SAVEas VBA code.
    By Ironman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2012, 02:32 AM
  2. SaveAs via VBA code
    By ainnocent1983 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2010, 06:22 AM
  3. code for saveas
    By pichai in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2008, 09:32 AM
  4. SaveAs Code
    By Dohko in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2007, 03:29 PM
  5. SaveAs code
    By wmjenner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2007, 12:35 PM
  6. [SOLVED] SaveAs Code
    By Ronbo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2006, 11:55 AM
  7. [SOLVED] Unexpected SaveAs prompt for workbooks with pivot tables
    By KentL in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2005, 06:05 PM
  8. [SOLVED] Workbooks.Add and SaveAs don't occur
    By Gareth Roberts in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2005, 10:06 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