+ Reply to Thread
Results 1 to 5 of 5

macro saves sheet with excel 2016

  1. #1
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    macro saves sheet with excel 2016

    Hello,
    the attached macro is a little dated and was created in 2001 with excel 2000.
    He has always done his job with the later versions of excel:

    Please Login or Register  to view this content.

    after saving, the "blank" saved sheet opens without colors and macros to be sent as an e-mail.
    Up to excel 2010 has always worked, now trying with excel 2016 after you view the saved sheet to send it you have to click on the top:
    file> share> mail but unfortunately I do not understand why the file button is blocked.
    To be able to send this sheet you have to go "physically" in the created sheet and in this the file button works.
    Mysteries .....
    I enclose the complete workbook?
    Greetings and thanks in advance.
    max_max

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: macro saves sheet with excel 2016

    Yes enclose the workbook.

  3. #3
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: macro saves sheet with excel 2016

    Change in macro1 the save path:

    sPath = "C:\Users\massimo\Desktop\salvati"

    max_max
    Attached Files Attached Files

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: macro saves sheet with excel 2016

    I am not finding a problem Max_Max

  5. #5
    Forum Contributor max_max's Avatar
    Join Date
    06-28-2013
    Location
    italy - venice
    MS-Off Ver
    Excel 2007
    Posts
    1,693

    Re: macro saves sheet with excel 2016

    The problem is only with excel 2016.
    The newly created sheet does not have the active toolbar buttons, they are locked.
    max_max

+ 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. Replies: 1
    Last Post: 09-18-2017, 08:27 AM
  2. [SOLVED] Macro that saves data in new work sheet and modifies the new sheet
    By bouncingbudha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2015, 11:22 PM
  3. Excel Macro Enabled Template - Saves as .XLSX by default
    By ddarko77 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2013, 04:16 PM
  4. Macro that saves specific worksheet as a new excel file
    By buckhunt122 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-06-2011, 10:57 AM
  5. Replies: 3
    Last Post: 09-11-2009, 03:38 AM
  6. Macro that saves excel workbook as PDF??
    By mydogpeanut in forum Excel General
    Replies: 1
    Last Post: 05-25-2006, 04:00 PM
  7. Replies: 1
    Last Post: 12-06-2005, 12:25 PM

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