•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Macro running on all workbooks
Our take
Creating a macro that runs smoothly across different workbooks can transform your data handling process, making it more efficient and user-friendly. If you've experienced formatting changes affecting other open workbooks, it’s essential to adjust how you save and run your macro. By saving the macro in your personal macro workbook or as a standalone file, you can ensure it operates independently.
First. I’m really not an Excel expert so please explain things slowly.
I regularly download a report that has a lot of raw data. I need to rearrange and rename columns and delete others that aren’t pertinent to my task.
I tried creating a macro to help with this. I simply clicked record macro, saved it in a new workbook, made the formatting changes, end recording.
When I went to run the macro I find it’s changing the formatting of other workbooks I have open as well. Obviously that creates a huge problem.
Question:
How do I create a macro that I can save on my computer and share with others so the formatting of this report can be quick and easy?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Need macro advice! Saving longer numbers as strings to show all the charactersDesktop, Excel 365 Build 19929.20106 Click-to-Run, Beginner We have a macro that generates new files using a list of data. Sometimes that data is completely numerical with over 15 digits. Excel keeps reformatting these numerical entries using scientific notation, which screws up the output files. Right now I have to manually check the output files and reformat the affected ones so that all then hidden characters are shown. Can someone please advise on how I can update the macro to automatically convert these numbers into strings that show all the characters? The data is of variable length, but I'm pretty sure it's always under 20 characters. This problem only affects one cell of the output file. Everything else is generated without issue. It's basically the problem of "how do I make Excel macro copy-paste the entire FedEx tracking number correctly" but the data isn't consistently 16 characters and is frequently alphanumeric. EDIT: I'm open to even stupid and booleg solutions like "add a hidden text character before transferring the data" to force this to work. The output files are basically just printables. I just don't know anything about macros and do not have time to learn. submitted by /u/Umklopp [link] [comments]
- Doing the same steps over and over to an excel doc downloaded from salesforce - how to simplify?hi, i download an excel file from salesforce multiple times per day and do the same formatting/functions with it over and over. i know that there must be an easier way than doing this manually. i basically download the excel file from salesforce, do some formatting (make the rows all the same height, format numbers to be $0.00, filter by a column to remove zeros, then subtotal by a specific column). how can i do this quicker. macro? submitted by /u/beancounter_00 [link] [comments]
- Macros to Automate or Other OptionQuestion here. Every month I'm copying pasting from one system into excel. Reformat, filter, add formulas, paste into GP. Rinse and Repeat I have been meaning to automate it so I dont have to do same formulas and formatting each month on each tab. I know how to record macros but I wasnt ever that successful doing with others. With all the advances lately is there other options besides that? Copy paste out is best option for export for now and so is paste into GP. That part is fast enough I dont care. submitted by /u/Dio_Rocks [link] [comments]
- Excel macros work locally but not properly from SharePoint (data validation errors)Hey everyone, I’m troubleshooting an Excel (.xlsm) file stored in SharePoint that relies on macros, and I’m running into a confusing issue. Originally, users were getting the standard macro block error: “Microsoft has blocked macros from running because the source of this file is untrusted” As a test, I copied the file locally (outside of SharePoint), and everything worked perfectly — macros ran with no issues. However, when using the file from its SharePoint location (via OneDrive sync), things don’t behave the same: The macro block error is no longer showing But users now get this error when entering data: “This value doesn't match the data validation restrictions defined for this cell.” It feels like the macros are only partially running or something isn’t fully initializing when the file is opened from SharePoint. To clarify: The file must remain in SharePoint (we can’t rely on local copies) The goal is to have users open and use the file directly from the SharePoint/OneDrive synced location Other teams in our organization have similar macro-enabled files working from SharePoint, so this should be possible At this point, I’m not sure if this is: A macro trust/security issue (still partially restricted?) A data validation dependency that isn’t loading properly Or something specific to how the file was built Questions: Can macros fully run from SharePoint/OneDrive synced locations, or are there limitations? Has anyone seen data validation errors like this caused by macros not executing fully? What’s the proper way to make this work — trusted locations, macro signing, or policy changes? Appreciate any guidance — this one’s been tricky to pin down. Thanks! submitted by /u/Icy-Alternative-3860 [link] [comments]