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 Exce...
Macros & VBA
Macros and VBA
Smitty Smith's avatar
Smitty Smith
Former Employee
Dec 05, 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