Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 01-24-2020, 11:33 AM
JonZatis JonZatis is offline Disappearring Macros Windows 10 Disappearring Macros Office 2019
Disappearring Macros
Join Date: Jan 2020
Posts: 1
JonZatis is on a distinguished road
Default Disappearring Macros

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?

Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Disappearring Macros How to automatically enable the macros upon opening a file with macros? laurieli Office 7 01-17-2016 08:56 AM
Macros Steveg Word VBA 0 08-18-2010 04:04 PM
Disappearring Macros Macros Desertwrangler Word VBA 6 06-25-2010 07:06 AM
macros trancetheory Outlook 0 05-11-2010 09:31 AM
Disappearring Macros Macros krdzal Excel 1 04-06-2010 07:43 AM

All times are GMT -7. The time now is 10:55 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd. is not affiliated with Microsoft