Generate VBA macros and a custom Excel ribbon from plain English — without the VBA editor
Prefer YouTube? Watch this walkthrough on YouTube →
If you want Excel automation but have never opened the Visual Basic editor, this demo is for you. It shows HISAB 360, an AI chat agent that lives inside Excel, turning a plain-English request into working VBA and a matching custom ribbon tab — so the macro you just described becomes a real button on the toolbar, ready to click.
In the video, the request is typed into the HISAB side panel in ordinary English. HISAB writes the VBA procedure, installs it into the workbook, then wires up a custom ribbon button that runs it. You review every step before anything is written, and each change is recorded in the workbook's audit log.
Open the HISAB panel and describe the macro in plain English
From the HISAB ribbon tab, open the chat panel and type what you want the macro to do — for example, "add a macro that highlights every row where the balance is overdue, then a button to run it." There is no need to name procedures, declare variables, or know any VBA syntax; you describe the outcome and HISAB handles the code.
Switch to a mode that can make changes
HISAB has four modes — Ask-only, Plan, Action and Automate. Ask-only just answers questions; to have it write code and install the ribbon you use Action (it asks before each change) or Plan (it lays out the steps first for you to approve). Authoring VBA also requires you to switch on macro-edit permission in HISAB's settings, and to tick Excel's Trust Center → Trust access to the VBA project object model — both are off by default for safety.
Review the VBA HISAB proposes
HISAB drafts the macro as a standard module and shows you the full procedure before installing it. You can read exactly what it does, ask for changes in plain English ("only flag rows over 60 days", "make it work on the active sheet"), and have it rewrite the code until it matches what you need.
Approve, and HISAB installs the macro into the workbook
Once you approve, HISAB writes the procedure straight into the workbook's VBA project — no copying and pasting into the editor. Because the macro now lives in the file, you must save as a macro-enabled workbook (.xlsm) for it to persist. Every macro HISAB writes is logged so you, or a reviewer, can see precisely what was authored.
HISAB builds the matching custom ribbon button
Next, HISAB creates a custom ribbon tab and adds a button bound to your new macro. It does this by writing the ribbon definition (customUI XML) into the workbook itself, then reopening it so the new tab appears immediately. Your macro is now one click away, with a label and icon, instead of buried in a macro list.
Click the button to run it — and tweak by asking
Press the new ribbon button and the macro runs on your data. If you want to change the behaviour or the button label later, just ask in chat; HISAB edits the VBA and the ribbon for you, keeping the code and the button in sync. The workbook stays on your machine the whole time — only sheet names, ranges, headers and a few sample rows are ever sent to the AI.
Why this matters for finance teams
For a finance team, the value is not just saving a few clicks — it is getting reliable, repeatable automation without depending on whoever once knew VBA. HISAB writes the macro and the button, so a routine task (flagging overdue rows, reformatting an import, refreshing a schedule) becomes a documented, one-click control any colleague can use.
It is also built for how accountants actually work. Macro authoring is off by default and gated behind both a HISAB permission and Excel's own Trust Center setting; nothing is written until you approve it; and every change HISAB makes is journaled to an audit log so a reviewer can reconstruct exactly what was authored and when. Your workbook data stays local, and you bring your own Anthropic or OpenAI key with no markup.
Frequently asked questions
Can I create a VBA macro in Excel without using the VBA editor?
Yes. HISAB 360 writes the VBA for you from a plain-English description and installs it directly into the workbook's VBA project, so you never open the Visual Basic editor. You review the proposed code in the chat panel and approve it before it is written. You can also ask for changes in plain English and HISAB rewrites the macro.
How do I add a custom button to the Excel ribbon that runs my macro?
HISAB builds the ribbon for you. After writing the macro, it adds a custom ribbon tab with a button bound to that macro by writing the ribbon definition (customUI XML) into the workbook and reopening it so the tab appears. Normally this requires hand-editing OOXML or a separate tool; HISAB does it in one step from chat.
Do I need to enable anything in Excel for HISAB to write macros?
Yes, two safeguards. In HISAB's settings you switch on macro-edit permission, and in Excel you tick File → Options → Trust Center → Trust Center Settings → Macro Settings → 'Trust access to the VBA project object model'. Both are off by default. Until they are enabled, HISAB cannot author or install VBA.
Will the macro and ribbon button be saved with my file?
Yes, but you must save the file as a macro-enabled workbook (.xlsm or .xlam). The macro lives in the workbook's VBA project and the custom ribbon is stored inside the same file, so both travel with the workbook when you share it. Saving as a plain .xlsx would strip the macro and the ribbon.
Try it on your own workbook
The 14-day trial is the full product — no card, no feature gates. The fastest way to evaluate HISAB 360 is on a real file from your own month-end.