Walter Jackson48 said:Give this a shot—open up your sheet, head over to Tools, then Macro, then Security, and set it to Low, then hit OK. Go ahead and Close the file by clicking Yes. Now, try opening it back up again. It’s possible the security level is just set too high, which would explain why the Macro won't run. Ever had that happen? It’s always something, isn't it?
Kyle Johnson2 said:Take a look at that tutorial—maybe it’ll actually help you get this sorted out?
- So, I was staring at my screen for way too long this morning—probably should have grabbed another coffee first—and I hit one of those classic Excel hurdles that just makes you want to throw the whole laptop out the window. Have you ever been there? You’ve got this massive spreadsheet, and for some reason, everything is color-coded. It looks great, sure, but now you need to actually *do* something with it. Specifically, you need to sum up all the values in cells that are a certain color. It sounds like such a simple request, right? Just "add up the blue ones" or "total the red ones." But if you go looking through the standard menus, it's like they forgot this was even a possibility. There isn't just some magical button labeled "Sum by Color" sitting there waiting for you. I started digging into it, thinking maybe there was a quick shortcut I missed, but it turns out it’s a bit more involved than just clicking a button. You can try using the Filter tool—you know, where you filter by color and then use the SUBTOTAL function—but honestly, that feels like a bit of a workaround, doesn't it? It works, but it's not exactly elegant. Then there's the "pro" route: VBA. Now, don't let that word scare you off—I know, I know, macros can feel intimidating—but writing a little custom script is actually a pretty solid way to handle this if you do it often. You basically create a tiny little function that tells Excel, "Hey, look at the background color of this cell and add it up if it matches." It’s a bit of a rabbit hole once you start tinkering with it, though... I ended up spending twenty minutes just adjusting the font size of my code. Classic me. Has anyone else run into this? Or am I just overthinking a problem that could be solved by just... I don't know, coloring the cells based on their actual values instead? Is it better to change how the data is organized from the start, or is it worth the effort to build a custom tool to fit the mess we already have? I'd love to hear how you guys tackle this when the spreadsheet starts looking more like a rainbow than a data set.
Thanks, but honestly—it’s no use. None of that really helps me out at all.
So, I went through this tutorial and pulled out the code—specifically that fourth example—and it works just fine in one specific file. But, the tutorial says if you want to use this code across all your Excel files, you should save it in your Personal folder, right? So, that’s exactly what I did. The problem is... it just won't work from there. I tried running a test Macro directly from my Personal folder, and that works perfectly fine—no issues at all—but as soon as I try to run this specific one for the color function, nothing happens. It's like it's hitting a wall. Does the code itself have some kind of built-in limitation that prevents it from running when it's sitting in the Personal folder? Is there something I'm missing here?