I created a macro-enabled reporting weekly on Excel for a number vendors that we represent. Each week, a template file is systematically replicated and renamed with the vendor name and week ending date in the file name. This file has a number of exception-based tools that we can use to efficiently manage our businesses.
I’ve been running this report (with periodic enhancements) for roughly 2 years without issue. A few weeks ago, this particular vendor file started behaving “quirky” in that the buttons that drive some of the macros disappeared, but the text labels for those buttons remain. A few quick call-outs:
- This issue never once occurred when we had Dropbox, and seems to align with our switch to OneDrive (this may be coincidental – I’m not sure).
- This issue only seems to occur for one particular vendor, despite that all other 30+ vendor reports are created from the identical report template.
- When I re-replicate the source template file and drop in the one vendor-specific report again, the buttons show as-intended.
- This happens sporadically, and is not consistent.
Where should I start looking to find the problem?
01-24-2020, 11:33 AM
Disappearring Macros
Similar Threads
How to automatically enable the macros upon opening a file with macros?
Windows 10 
Office 2019
Linear Mode
