Microsoft disables Excel 4.0 macros by default in Microsoft 365 – Computer
What has always surprised me is that there is almost no (formal) support from the IT department for the standard functionality of the application that is provided to every employee.
I regularly hear phrases like “personal risk”, but that is just not acceptable. As a corporate IT specialist, you will have virtually no responsibility for preventing “things suddenly stop working for some reason.”
I have seen many times in companies that the IT helpdesk simply rejects people stating that Excel documents with macros are basically not supported in terms of content when there are only people who are busy all day with SQL or something and have more than enough knowledge to analyze a simple VBA macro.
It often seems that the IT department refuses to think with the business.
The odd thing is that it is often recognized that there is a huge gap between IT, which is often concerned exclusively with the background, and employees who are generally only interested in the background. front-end content, but rarely try to bridge that gap. .
If VBA is widely used by users, there is a reason for this. If instead of just saying you don’t want anything to do with it, you visualize the usage, you might be able to determine if there really is an app that can facilitate users better or if structural improvements are needed. .
For some activities, maybe the easiest and / or cheapest way to do it is Office with VBA and why wouldn’t you want to set up and support that in an organized way.
If there really is an IT club with probably an expensive enterprise systems specialist from a company, why not have a specialist, project engineer, or whatever who can brainstorm with the employees?
Just spending a day looking at the work and taking stock of sometimes surprisingly easy to solve problems always gets things going.
More often than not, I have encouraged entire departments by reorganizing the folder structure, explicitly naming network and document locations, agreeing on layouts and formatting, and restructuring the configuration of old documents. Excel, which means the possibility of no macro functionality is longer due to invalid reference (which in my experience gives the most common error message) decreases exponentially.
I’ve heard many times that this stuff is not part of the IT department’s job. If there is interest in it, it is often assigned to an improvement team or club-type project manager, who still lacks computer literacy or knowledge of actual business operations and activities.
Ultimately, of course, it doesn’t matter what you fall for from a regulatory standpoint, as long as this is admittedly an underrated area for many companies where profit can often be made.
Lifetime zombie fanatic. Hardcore web practitioner. Thinker. Music expert. Shameless pop culture scholar.