macroland Macroland

Most Recent Macros

Import CSV
Imports a selected CSV file into the current page as a table
Add link
ADD A LINK-TO-ORIGINAL-FILE THAT IS MISSING Procedure: 1-Shift + right click on the file 2-Choose Copy as Path 3-Go to OneNote, Onetastic Link > Add Link (the macro) 4-Paste it in the box with Ctrl+V
Crosslink paragraphs
After using "Add current paragraph link to currently selected text", copy that text to another paragraph or page, then use this macro to crosslink those paragraphs. Great for creating Index pages.
Random Page
Go to a random page in current Section/Section Group/Notebook/All Notebooks (Excludes Recycle Bin) - Just for fun ;)
Copy Current Page to Other Notebooks
Copies current page, or selected pages in the current section to other notebooks. You can select one or more target notebooks, or pick all notebooks.
Template Notebook Structure
Save section hierarchy of current notebook (not pages) into a templates store and later apply those templates to new notebooks. Create a new empty notebook to apply templates.
Paste as Text
Pastes what is in the clipboard as plain text
Move Following Content Up
Move objects upward on the page with a configurable offset. - If multiple objects are selected: - Only the selected objects will be moved upward by the given number of pixels. - If exactly one object is selected: - All objects positioned below it will be moved upward by the offset. - Works with images, outlines and embedded files. - Objects retain their relative spacing after movement. - Default offset is 30 pixels, but can be customized in the dialog. - Requires at least one object to be selected.
Resize and Space Selected Images
Resize and arrange images on the current OneNote page with flexible options: - Resize images by percentage (%) or pixels (px) - Pixel mode is only available when at least one image is selected - Pixel values are auto-filled from the first selected image - Optional: maintain aspect ratio when only one pixel value is entered (set the other to 0) - If no image is selected, only percentage mode is available - Option to adjust vertical spacing only, without resizing - Choose to apply changes to all images or selected images only - Automatically arranges images vertically with custom spacing - Error message shown if no images are found on the page
Show Image Size in Pixels
This macro shows the width and height (in pixels) of the selected image on the current OneNote page. If no image is selected, it will show an error message.
Resize and Space Selected Images
This macro resizes and arranges images on the current OneNote page. You can specify the width and height as a percentage of the original size, and optionally add vertical spacing (in pixels) between each image. Additionally, you can choose to apply the changes only to selected images.
V3Custom Daily Planner w/two month calendar
Edited version of Daily Planner Page from Onetastic: Day, week, month daily planner with current and next month calendar on top of page. Page is sized to fit NA3 portrait, title (short date) in top left corner of page. You can turn off the OneNote page title and save as template to have a clean background.
Tax Client Template - Tax Preparation Workpaper
Template for Tax Clients - Tax Preparation
Convert Similar Text to Heading 1
Selects all text of similar formatting and converts it to Heading 1
ESP_Insert dated page at top
SImple macro to insert a new page at the top of the open section and insert the date at the start of the page title
Window Manager
Save sets of OneNote windows and reopen them later
Sort Pages by Date
Sorts pages in current section or notebook by created or last modified date
Resize all Images on Page to One Standard Width
Resizes all images on the current page to a standard width.
Change Container Position
Change Container Position with x and y coordinates
Set Container Width
Sets the width of selected containers
Code Style
Changes the text style to code (Consolas 10 pt, green color). Only affects selected text, not the whole paragraph.
Insert Monthly Calendar
Inserts a calendar of the selected month and year
Horizontal list to vertical list
Converts an horizontally separated list (item1, item2, item3, etc.) to a vertical list (bulleted, to do or table). Horizontal separator is customizable (defaults to ", ", that is a comma and a space) and the first character of each individual item can be forced to uppercase. Table option is ideal when a comma separated list of words must be formatted to some sort of lexicon where the left column contains the items and the right column would contain the definitions as a blank column is automatically added to the right of the column of items.
Move Image Coordinates
Move to left or right by x units, and/or down or up by y units.
Outlook Meeting Date Stamp
This macro will change the creation date of each page in the current section with the time of the meeting, if the page contains meeting notes, allowing them to be sorted by the meeting date. This has been made specifically for meetings sent to OneNote from Outlook.
Where am I +
Inserts a breadcrumb showing where the current page is in the hieararchy of notebooks / section groups / sections / Parent Pages. Automatically removes the old breadcrumb.
Insert Related Page Links by Title Match
Insert Related Page Links by Title Match. Used for Trading Journal to insert the past trades of the ticker on the current page.
Text Snippets
Store commonly used text snippets and insert them when you need
Set all Section Titles to Calibri 16 with Color
Changes Title of each page in the current section to Calibri, Font Size 16, with Color Picker
Expand/Collapse Outlines
Toggle Expand/Collapse, or expand to the selected outlines to the chosen level (Level 1 to 9 as well as all levels).
Collapse Pages in Current Section
Collapse all pages in the current Section
Section fonts to Bruneii
All fonts in current section change to Calibri. Titles to Calibri Light, font size 20. Texts to Calibri, font size 11.
Current Location - Popup Message
Presents a dialog box displaying the full hierarchical location of the current page.
Create Section Groups from list of titles
Creates section groups in the current notebook (or section group) from a given list of titles separated by semicolon (;)
All Section Font Arial Black, Size14; Spaced 0 Before, 9 After
All fonts change to Arial black size 14 , Titles to Size 20, Paragraph spacing 0 before, 9 after
All Page Font Arial Size 14
All fonts change to Arial size 14, Titles to Font Size 20. 1 page effect
Create Index Page
Creates a new page with a category index at the top where each category is a hyperlink to sections below. Categories are comma delimited lists of strings (i.e "A,B,C,D,E", "Monday, Tuesday, Wednesday", "⭐,⚡,❓", etc.). An index page can serve as a repository for notes that need to be filed by category.
Function
Use sum, average, etc. functions on tables. Select a cell, a column or a row to apply the functions.
Rename Current Section
Renames the current OneNote section per DialogBox user input. // Get the current section $Section = GetCurrentSection() // Create a dialog box $DialogBox = DialogBox_Create("Rename Section", "Set the new section name:") // Add a text box to the dialog box DialogBox_AddTextBox($DialogBox, "New Section Name:", "txtSectionName", "", true) // Show the dialog box DialogBox_Show($DialogBox) // Get the value entered by the user $NewName = $DialogBox.controls["txtSectionName"] // Rename the section $Section.name = $NewName --code generated using Microsoft Copilot, slight human editing by Michael Steger
Proofing Language Text -> Irish (IE)
Sets the proofing language on selected text to Irish (ga-IE)
Text to Code
Converts selected text into Code table with line number and font 'Consolas' .
Text To Code V1.1
Takes code pasted from an IDE and makes a code like block, preserving color and disabling the spell check.
Diary Pages
Create a page for each day in the selected month with date of the day as the title
Monthly Calendar With Task List
Creates a monthly calendar with task list for each day
Resize selected images 80%
Resize selected images 80% in a page.
Indent-Level-to-Style
Sets Style (header levels) based on indenting performed when notes were taken.
Insert YYYY년MM월DD일W요일
Insert YYYY년 MM월 DD일 W요일
Auto Generate Links to Pages
Automatically creates hyperlinks on any text that matches a page title within the selected pages, all pages in the current section, or current notebook
BLACK TEXT
Changes text font to BLACK
TOC in Current Page
Creates a table of contents from heading in the current page and inserts at the top of the page. Optionally it adds "Back to Top" links to the headings.
Set Page Titles
Sets the titles of each page in the current section to the values in the given semicolon-separated text
Copy Pages to ClassNotebook by Student
Will distribute app generated Pages to specific student sections in a ClassNotebook. Titles of the generated Pages must be in the format ClassNotebookNickname/StudentSection/Section/ActualTitleofPage I have used PowerAutomate to create generated OneNote Pages (as outlined here: https://onenoteschool.com/generating-onenote-pages-distributing-them-to-the-correct-student-in-a-onenote-classnotebook/ ) but any process to create Pages is fine so long as the Page Title is as given. The functions providing distribution of the actual Pages, recently updated to include Images and Files, come from Omer Atay, with appreciation.
Paragraph Spacing = 20
Sets paragraph spacing to "20"
Add icon to page title
Adds an icon (emoji) to the front of the title, for easy reference of page type. For example, use "✉" as the first character to easily identify pages created from emails.
Expand/Collapse All Outlines
Collapse/expand all lists in the current page at the same time.
Show E-mail Addresses
Adds e-mail addresses to mailto: links. Can be used to display e-mail addresses on meeting details pages
Reverse Images
Reverses order of images vertically. Useful if a printout is printed in the reverse order.
Take Images out of Text Box
Some Macros will not work when an Image is in a Text Box. (ie. Moving, setting as background, etc.) This Macro takes all images in Text Boxes and copies them so that they are no longer in a text box. Maintains approximate position on page
Search & Highlight
Search text in the current page, section or notebook and highlight with the selected color
Increase Font Size
Increases font size of all text on the page by 1
Decrease Font Size
Decreases font size of all text on the page by 1
Box Drawing
Converts a box drawn with +, -, and | characters into one drawn with Unicode box drawing characters. Can convert back and forth from 5 different formats.
Search & Replace
Search and replace text in the current page, section or notebook
Clear Table
Clear all cells in the selected table
See All Macros