Changelog

What's new in MacroRoni

Every version and what changed in it. MacroRoni updates itself, so you always have the newest one.

2.0.0

New

  • A new Home screen: Scout greets you by name, with quick ways to start, the macros you were working on, anything waiting for you (deliveries, quotes, replies, updates) and a tip.
  • Meet Scout: the first time you sign in, Scout pops up and asks what to call you. You can change it any time in Account.
  • Community: a new section in the sidebar with recipes shared by other MacroRoni users. Search them, sort by newest or most used, and see how many people use each one. Every recipe is checked by our team before it appears.
  • Community builds are made by other users, not by MacroRoni, so the first time you open Community you are asked to accept that; you only need to do this once on your account.
  • Share your own: in My macros, open a macro's … menu and choose Share to Community. Only the steps are shared, never code or your workbooks, and you choose whether your name is shown. You can delete a recipe you shared at any time.
  • Safe by design: recipes can't open web pages, send email, add links or create files, and anything you open from Community starts with a backup and an undo point turned on. Nothing runs until you run it in Excel.
  • See something wrong? Use Report on any recipe and we'll take a look.

Improved

  • The privacy policy explains what's shared when you share a recipe, and Delete my cloud data removes your shared recipes too.

1.9.0

New

  • Custom macros: a new page in the sidebar where macros we build for you arrive, marked "Delivered by 3 Rivers Technology Group". Add one to My macros with one click; when we send a fixed version, you'll see "Update" and the notification bell lets you know.
  • Request a custom macro: describe what you need, get a quote with a price and a date, and accept or decline it right in the app. Nothing is owed unless you accept.
  • Save one macro as a file: choose "Save as file…" in a macro's … menu in My macros. Open it on any computer with MacroRoni from Ctrl+K → "Open a macro file or backup", or drop the file on the window.
  • "What this macro does" PDF: on the last step of the builder, choose Save as PDF for a plain-English document of every step, what it changes, its risk and backup, with a place to sign. Handy for sign-off, clients and auditors.

Improved

  • The privacy policy covers custom macro requests and delivered macros, and Delete my cloud data removes them too.

1.8.3

Improved

  • Behind-the-scenes improvements that help us spot and fix problems sooner.

1.8.2

Improved

  • Behind-the-scenes improvements that help us look after your account and answer you faster.

1.8.1

New

  • If a MacroRoni version ever has a serious problem, we can now ask everyone on it to update. You'll see a short "Please update MacroRoni" screen with an Update now button, and your macros come with you.

Improved

  • If a feature such as Messages or share links is ever paused for maintenance, MacroRoni says so instead of showing an error, and everything else keeps working.

1.8.0

New

  • Notices from the MacroRoni team now appear at the top of the app, for example planned maintenance, a problem we're fixing, or a reminder to update. Times are shown in your own time zone, and important notices also appear in the notification bell.
  • You can close everyday notices with the ×. Critical ones stay until they end.

1.7.5

New

  • Messages greets new users with a welcome from the MacroRoni team, and tells you when to expect an answer: we usually reply within 1 business day.
  • When we close a conversation, you can tell us whether it helped with a thumbs up or down. If it didn't, reply and the conversation opens again.

Improved

  • The guest trial is now a real preview: guests can build macros and preview the changes, but the VBA code stays hidden until they create a free account.

1.7.4

New

  • Try MacroRoni before making an account: choose "Try it first" on the sign-in screen to build macros, check their steps, preview them on your own workbook and use Excel Intelligence as a guest.
  • When you're ready to save, copy or export a macro, MacroRoni asks you to create a free account. The macro you're working on stays on screen, so nothing is lost.
  • New guests get Scout's one-minute walkthrough, just like new accounts.

Improved

  • The sign-in page opens in Create account mode when you come from the guest trial.

1.7.3

New

  • Send to Excel: one click puts your macro straight into a workbook you have open in Excel. No more copying, pasting or importing files. Find it in the code panel and on the last step of the builder.
  • Choose which open workbook gets the macro, and tick Run it now to run it straight away. If your macro starts from a button, a shortcut or when the workbook opens, MacroRoni can set that up too.
  • Sending a macro again replaces the earlier version in that workbook instead of adding a second copy.
  • The first time, MacroRoni shows you the one setting to turn on in Excel (Trust access to the VBA project object model). Copy and paste still works any time.

Improved

  • After sending, MacroRoni reminds you to save as an Excel Macro-Enabled Workbook (.xlsm) when a regular .xlsx would drop the macro.

1.7.2

New

  • When something unexpected goes wrong, MacroRoni now offers to send it to support. One click opens Feedback with the problem already written and the diagnostic report attached, and our reply arrives in Messages.
  • Terms of use: plain-English terms are now on the About page and online next to the privacy policy. Everyone is asked to read and agree to them once; your choice is saved with your account.

1.7.1

New

  • A Feedback button at the top, next to the mail icon and notifications bell, so you can report a problem, share an idea or ask a question from any page.
  • Feedback now arrives as a conversation in Messages, so you get our reply right in the app. If you attach the diagnostic report, it goes with your message.
  • Messages has a short list of common questions, such as turning on macros in Excel and where to paste the code, and you can mark a new message as a Question, Problem or Idea.
  • Meet Scout: new users get a one-minute animated walkthrough showing how to describe a macro, check its steps, preview it, run it in Excel and use Excel Intelligence. Watch it again any time from Guided tour, which now lets you choose Scout's walkthrough or the interactive tour of the real app.

Improved

  • A new MacroRoni logo and desktop icon: a spreadsheet with a bent "run" arrow, for macros that run on your sheets. It is now the same on the desktop, taskbar, installer, sign-in screen and About page.
  • The logo draws itself and the name slides in when MacroRoni opens. Point at the logo to see it run again. If Windows is set to reduce animations, everything stays still.

Fixed

  • Add leading zeros no longer changes TRUE/FALSE cells.

1.7.0

New

  • Messages: write to the MacroRoni team from inside the app and get replies in the same place. Open it from the new mail icon at the top, next to the notifications bell, or from Messages in the sidebar.
  • The mail icon and the sidebar show when there is a new reply.
  • You can include your MacroRoni and Windows versions with a new message, which helps us fix problems faster.

Improved

  • The privacy policy covers support messages, and Delete my cloud data removes your conversations too.

1.6.1

New

  • Settings → Usage check-in: while you are signed in, MacroRoni tells your account every few minutes that it is open and which version you have, so we know when updates reach everyone. Only the latest check-in is kept, the team sees totals only, and you can turn it off at any time.

Improved

  • The privacy policy explains the check-in and how to turn it off.

1.6.0

Fixed

  • The Excel Intelligence health score now sits neatly in the middle of its ring, and a perfect 100 fits inside it too.

1.5.0

New

  • Over 100 new ready-made macros in the Starter gallery, now 123 in nine categories, including Text & IDs, Dates & time, Print & share and Workbook tools.
  • 24 new builder actions: fill down empty cells, round numbers, add leading zeros, keep only digits, keep text before or after a character, remove all spaces, highlight the highest or lowest values, highlight cells containing a word, highlight weekend dates, data bars, color scales, sort sheet tabs, show all hidden sheets, list sheet names, add a note, remove links, page header, print gridlines, center on the page and narrow margins.
  • Typing a request understands the new actions too, for example "add leading zeros to column E" or "highlight the top 5 in column B".
  • Inspect a macro now gives a safety score from 1 to 100, explains what each macro does and how it starts, lists the sheets, cells, web addresses, files and programs the code names, gives quality tips and a checklist before you run it, and shows the code with every flagged line marked. Click "show in code" to jump straight to a line, search the code, and save the review as a report.
  • The Inspector also spots more risky code: system tools such as PowerShell, passwords written in the code, very hidden sheets, timers, add-ins, start-up folders and changes to macro security.

Improved

  • Everything lines up and stays inside its box at every window size and text size: the title bar, the New macro button, the getting-started steps, the Excel Intelligence worksheet picker and score card, and Settings → Text size.
  • The scanning screen fits small windows and large text.
  • The Starter gallery search moved to the top, and the category highlight follows you onto the second row.

Fixed

  • Starter gallery cards with longer titles no longer cut off their bottom line, and the Use this starter button stays visible in long previews.
  • Typing "repeat the header row on every page" now repeats row 1 on each printed page, and "delete the top 2 rows" deletes rows 1 to 2 instead of removing duplicates.

1.4.0

New

  • Meet Scout: Excel Intelligence has a new animated helper. Scout scans your workbook step by step, then reacts to what it finds.
  • Workbook health score: every workbook gets a score from 1 to 100 that spins into place, with a list of exactly what lowered it and how many points each thing cost.
  • Fix all safe issues: one button adds every low-risk tidy-up (extra spaces, hidden characters, numbers stored as text, different spellings) with a backup and undo, and shows the result on your sheet.
  • Smarter checks: near-duplicate rows and repeated IDs, different spellings of the same value, formulas that don't match the rest of their column, totals that don't add up, lookups with missing matches between sheets, and email, phone, ZIP and date values that look wrong.
  • Slow workbook check: finds whole-column formulas, volatile functions like NOW and INDIRECT, and formatting far beyond your data.
  • Column profiles: see the type, fill rate, most common values and a small chart for every column.
  • Suggested summaries: one click adds a summary sheet with totals by category.
  • Compare two versions of a workbook to see added, removed and changed rows.
  • Save a report: save the findings as a web page you can send to anyone.
  • Scan history: workbooks saved to your account remember their score each time you scan, so you can see it improve.

1.3.0

New

  • Share links: share any macro with a short code like MR-7K2Q-9XWD. Anyone signed in to MacroRoni can open a copy with it, and you can turn a link off any time (Account → Shared links).
  • My starters: save one of your macros as your own starter, and find it in the Starter gallery under My starters.
  • Back up and restore: save all your macros (with folders, tags and pins) to one .macroroni file, and restore them from it. Restoring never overwrites a macro you already have.
  • What's new: the About page now lists every version and what changed in it.
  • Text size: make everything in MacroRoni larger in Settings → Appearance.

Improved

  • MacroRoni reopens on the page you were on, and the builder remembers its preview tab and action category.
  • My macros: less-used actions (rename, copy, share, folders, Trash) are in a tidy … menu on each macro.

1.2.2

New

  • Updates in one click: choose Update now and MacroRoni closes, updates and reopens by itself. No installer to click through (starting with the update after this one).
  • When an update is ready, a window asks Update now, Later or Remind me tomorrow. Later keeps a glowing Update ready button at the top of the window.
  • Feedback: send a bug, an idea or a question to the MacroRoni team from Settings, About or Ctrl+K, with an optional diagnostic report.
  • Announcements from the MacroRoni team appear in the notification bell.
  • My macros: search, folders and tags. Filter by folder, or type #tag to find macros fast.
  • A getting-started checklist on the home page walks you through your first workbook, macro and export.

Improved

  • MacroRoni checks for updates every hour and when you come back to it, and shows how much is left to download.
  • If an update ever fails to install, MacroRoni tells you and tries again.

1.2.1

New

  • New macro button: bigger, with a menu to start from a blank macro, a starter, a description or a share code. Press Ctrl+N for a new macro.
  • Undo after starting a new macro: the notice at the bottom has an Undo button that brings your previous macro back.
  • My macros: pin your favorites to the top (and to the top of Ctrl+K search), rename a macro (its version history comes along), or make a copy.
  • Recently opened: your last macros are on the home page, one click away.
  • Keyboard shortcuts: press ? to see them all.
  • About and the privacy policy now include a contact email.

Improved

  • Starting a new macro asks first if the current one has steps that are not saved.

1.2.0

New

  • Notifications: a bell in the title bar shows updates, an unfinished macro, changes waiting to upload, macros about to leave the Trash, and sync problems. Mark them as read one at a time or all at once; MacroRoni remembers.
  • Trash: deleting a macro now moves it to the Trash for 30 days. Open My macros, then Trash, to restore it or delete it forever.
  • Quick search: press Ctrl+K (or use Search in the title bar) to jump to any page, open a saved macro or a starter, or run an action.
  • Work offline: macros you save without an internet connection are kept on this computer and upload automatically when you are back online. Your saved macros also open while offline.
  • About: who makes MacroRoni (3 Rivers Technology Group), what it does, and our privacy policy. The privacy policy is also on the sign-in screen.
  • Account: change your display name, download a copy of your data, or sign out on all computers.

Improved

  • Lists now say "1 step" instead of "1 steps".

1.1.0

New

  • MacroRoni now uses your account: sign in with Google, GitHub or email to get started. Macros you saved on this computer before can be added to your account the first time you sign in.
  • Starter gallery: 19 ready-made macros for cleaning data, reports, highlighting, calculations and sheet safety. Browse, preview the steps and open one in the builder.
  • Version history: every time you save a macro, your account keeps a copy (the newest 20). Open My macros and choose History to go back to an earlier version.
  • Diagnostic report (Settings): if something goes wrong, create a report, read it, and copy or save it to send to whoever is helping you. Nothing is sent automatically.
  • A "What's new" window shows the changes in each update, and again once after it installs.
  • Google and GitHub sign-in finish on a page that says you can close the browser tab.

Improved

  • Signed in without internet? You can keep working; saving to your account resumes when the connection is back.
  • Each account has its own recent prompts, macros and unfinished macro.

Fixed

  • Recent prompts and macros from an account no longer stay on screen after signing out.
  • Deleting your cloud data now also clears it from the screen.
  • An unfinished macro from one account is never shown to another account on the same computer.
  • "Start new" no longer clears the wrong unfinished macro.

1.0.0

New

  • The first version of MacroRoni: describe a task in plain words, review each step with its risk level, preview the result on your own sheet, and export VBA for Excel.
  • Excel Intelligence finds problems in a workbook, and the VBA Inspector reviews macros written by others.