macroland Macroland

Most Recent Macros

Copy Current Page to Other Notebooks
Copies current page to other notebooks. You can select one or more target notebooks, or pick all notebooks.
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
Insert Monthly Calendar
Inserts a calendar of the selected month and year
Clear Table
Clear all cells in the selected table
Function
Use sum, average, etc. functions on tables. Select a cell, a column or a row to apply the functions.
1-inch Rule Lines
Adds 1-inch vertical and horizontal gray rule lines to the current page
Change Font in Selected Scope
Change text and title font and size in the current page, section, section group, notebook or all notebooks.
Insert Post-It
Inserts a post-it to the cursor position
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 come from Omer Atay, with appreciation.
Text Snippets
Store commonly used text snippets and insert them when you need
Changes title of each page in the current section to date of its creation
Changes title of each page in the current section to date of its creation
Tag Summary for Specific Tag
Creates a tag summary page for a specific tag. Up to three tags can be specified to find paragraphs that contain all those tags together or at least one of them
To-Do List with Section and Page Names
Small tweaks to Onetastic, RobertC, Sako73 version. Output modified to group by section group and tag type. Creates a page at the top of the section that lists all un-checked To-do tags. It is titled "TO-DO List (yyyy-mm-dd h:mm)".
Diary Pages
Create a page for each day in the selected month with date of the day as the title
Insert Horizontal Line
Inserts a horizontal line
Insert New Doku Page
Inserts a new Doku Page
To-Do List with Section and Page Names
Creates a page at the top of the section that lists all un-checked To-do tags. It is titled "TO-DO List (yyyy-mm-dd h:mm)".
All Section Font Corbel Light
All fonts change to Corbel Light, Titles to Font Size 20, Dark Grey Text,
Tag Created + Completed
Displays the creation and completion date/time of the To Do tag on the selected paragraph
Search & Select
Select search terms in the current page
Show Ink Anchors
Display the anchors of the currently selected ink shape for line shapes (arrows). Latest version of OneNote does not show ink anchors to move the ends of line shapes.
Word Count
Displays the number of words and characters on the page
Prepend Creation Date to Title
Prepends create date *yyyy-mm-dd* to tite if it does not exist
Window Manager
Save sets of OneNote windows and reopen them later
Sort Selected Paragraphs
Sorts selected paragraphs or list items
Prepend Custom Creation Date to Title ('yy.mm.dd ddd)
Prepend create date "'yy.mm.dd ddd" to title
Sample - Insert All Bullet Types
Insert all possible bullet types on a new page
Date as page serial number
Insert pg. s/n YYYYMMDDMMSS
TOC in Current Section
Creates a new page with table of contents of the current section
TOC in Current Notebook
Creates or updates table of contents of the current notebook
TOC in Current Subpages
Creates a table of contents of the current page subpages
Sort Pages by Date
Sorts pages in current section or notebook by created or last modified date
Sort Pages
Sort pages in current section or notebook by name, sub pages stay under their parent pages and sorted among themselves
Attachment List
Creates a list of attachment filenames in current section, section group or notebook. Provides page names and links back to the page and the embedded files.
Indent First Line
Indents first line of each paragraph in Current Page or Current Section, ignoring the following cases: Paragraph in the table, bulleted paragraph, numbered paragraph, blank paragraph, paragraph other than default style is set, "center" or "right" alignment is set.
All Font Calibri - Titles Calibri Light 16 - Pages Calibri 11
All fonts in section: Calibri. Titles: Calibri Light size 16. Pages: Calibri size 11.
Add Footnote
Adds a footnote to the bottom of the page and links the current cursor position with the footnote. If there is any text selected, it is moved to the footnote
Insert Formatted Date
Inserts a selected date in the selected format
A4 Paper Boundaries
Adds lines to the page to show A4 paper boundaries
Insert One Cell Table
Insert a single celled table in an outline.
Convert File Paths to Hyperlink
Adds a file:// hyperlink to selected paragraphs which must contain a file path. E.g. if a selected paragraph contains c:\test.txt, it will convert this to a hyperlink to file:///c:\test.txt
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.
Number of Pages
Displays number of pages in current Section/Section Group/Notebook/All Notebooks (Excludes Recycle Bin)
Sort Sections
Sort each section in current section group alphabetically by name
Sort Notebooks
Sort notebooks alphabetically by name
No Spell Check
Removes spell check (red squiggles) from selected text
Daily Planner Page
Planner with Task List and a Daily Notes page. This can create a single page with for the selected day or a number of pages for each day in the selected range.
tag un/completed sort,created/completed date entry
This Macro sorts the tags in Completed and uncompleted order. It also appends created date and Completed date in the end.
Insert Dated Page
Inserts a new page with todays date as title. updated 2022-10-04 by AGB to remove section request and remove placement at top of list
Auto-fill
Auto-fills selected table cells using data from the first few selected cells
Resize Images by Pixels
Resizes all images and printouts in the current page to a specified pixel size.
ALL Page Titles -> Calibri Light 16
Updates the Titles of ALL Pages in ALL Sections of the Current Notebook to Calibri Light 16.
ALL Page Titles -> Calibri 16
Updates the Titles of ALL Pages in ALL Sections of the Current Notebook to Calibri 16.
Insert Time Last Modified (ISO format date and 24h)
For each outline in the current page inserts the last modified date/time as YY-MM-DD (ISO 8061 format) HH:MM in 24 hours format (no "at" or "pm" suffix)
Insert Time Last Modified (ISO format date)
Inserts the last modified date/time as YY-MM-DD (ISO 8061 format) HH:MMpm for each outline in the current page
Undim Tags
Undims tags on the current page, section, section group, notebook or all notebooks, so that they show up in tag search results
Page and Title modifier for imported Outlook Emails
This macro works for e-mails imported in OneNote from Outlook only. The user prompt is in french. What it does is set the OneNote page date to the one of the e-mail within it. Added to that, it also changes the title of the page by adding the date of the e-mail at the beginning of it and add a few glyphs showing that it's an e-mail, if there are any attachments and finally if the e-mail was sent or received. The macro handles dates in german, french and italian.
Insert Yearly Calendar
Inserts a calendar of the selected year
Set Column Widths
Sets the column width of the selected table on the current page to the specified value.
Auto Generate Links to Pages
Automatically creates hyperlinks on any text that matches a page title within the section
See All Macros