Forum Discussion

Luke Hunter's avatar
Luke Hunter
Copper Contributor
Dec 05, 2017

Macros no longer working in Excel 2016

I built a macro-enabled spreadsheet in Excel 2013 to automate the preparation of my company's State Sales Tax return each month (over 140 localities require a report with or without sales). When Excel 2016 came out, the code used to automate my process stopped working. Research into the issue at that time revealed that Microsoft had mistakenly turned off macros from the product. Does anyone know if they ever fixed the problem, or if there is a work around to get my macros working again?

Macros & VBA
Macros and VBA
  • Smitty Smith's avatar
    Smitty Smith
    Icon for Microsoft rankMicrosoft
    Dec 06, 2017

    Hi Luke,

     

    VBA for Excel 2016 for Windows is alive and well. Can you point out what's not working? 

    • Mike inCT's avatar
      Mike inCT
      Copper Contributor
      Jan 16, 2018

      periodically, in the past, macros would disappear from a xlxm file that I have been working on.

       

      I did a lot of work last night and, then this morning on a separate project & file. 

       

      Now , when I open those xlsm files, there's no macroes. Vanised.

       

      what's going on? Anybodt with any ideas?

       

      Mike

Resources