macroland Macroland

Macros by: Onetastic ★

Insert Monthly Calendar
Inserts a calendar of the selected month and year
Sort Pages
Sort pages in current section or notebook by name, sub pages stay under their parent pages and sorted among themselves
TOC in Current Notebook
Creates or updates table of contents of the current notebook
Search & Replace
Search and replace text in the current page, section or notebook
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.
Insert Horizontal Line
Inserts a horizontal line
TOC in Current Section
Creates a new page with table of contents of the current section
Weekly Planner
Inserts page with a section for each day in the current week
Resize Images
Resizes each image and printout in the current page by given percentage. This extension allows to choose either all images or the selected image only on the current page to be resized.
Sort Sections
Sort each section in current section group by name
Sort Pages By Date
Sorts pages in current section or notebook by created or last modified date
Sort Notebooks
Sort notebooks by name
Daily Planner Page (Today)
Planner with Task List and a Daily Notes page. This will create a single page with today's date on it.
Blackboard page
Changes the background color of the page to black, sets all font to white, and optionally removes date/time under title
Function
Use sum, average, etc. functions on tables. Select a cell, a column or a row to apply the functions.
Word Count
Displays the number of words and characters on the page
Text to Table
Converts selected text into table
Insert Yearly Calendar
Inserts a calendar of the selected year
Search & Highlight
Search and replace text in the current page, section or notebook
List Notebooks
Creates a page with a list of all open notebooks and links to them
Weekly Planner for each day with Done&TODO
Inserts page with a section for each day in the current week with Done, Problem and TODO.
Insert Monthly Calendar - Alternative
Inserts a calendar of the selected month and year; Large format option enables setting a width and height.
Set Page Background Color
Pick a color to set the page background
Where am I
Inserts a breadcrumb showing where the current page is in the hieararchy of notebooks / section groups / sections
Insert Double Horizontal Line
Inserts a double horizontal line
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
Sort Table
Sorts selected table by selected column
Set Section Color
Sets Section Color to selected color
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.
UPPER CASE
Convert selected text to upper case
Recent Edits
Displays a summary page of recent edits in current section/section group/notebook or all notebooks
Number of Pages
Displays number of pages in current Section/Section Group/Notebook/All Notebooks (Excludes Recycle Bin)
Increase Font Size
Increases font size of all text on the page by 1
Auto-fill
Auto-fills selected table cells using data from the first few selected cells
Select Images
Selects all images on the page
Capitalize Each Word
Capitalize each word in the selected text
To-Do List with 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)".
Sublime Theme
Makes the background color of the page dark gray and converts existing text to white. Based on the Sublime text editor. Note: Does not force the Automatic Font to White. Pending fix.
Diary Pages
Create a page for each day in the selected month with date of the day as the title
lower case
Convert selected text to lower case
Sort Selected Paragraphs
Sorts selected paragraphs or list items
Decrease Font Size
Decreases font size of all text on the page by 1
Create Task Cards
Create tasks cards on the page
No Spell Check
Removes spell check (red squiggles) from selected text
Code mode
Changes the text style to code (Consolas 10 pt, with a very light background, reminiscent of Evernote Code Blocks). Works even when no text is selected.
Clean Hyperlinks
Removes all friendly hyperlinks in the current page
Tag Summary with Page Names
Creates a tag summary page with page names and links for each tag. Orders the results first by tag, then by the page they appear in.
Where am I +
Inserts a breadcrumb showing where the current page is in the hieararchy of notebooks / section groups / sections / Parent Pages. Automatic remove the old breadcrumb.
Clean Authors
Cleans author information from the current page
Monthly Planner Pages
Creates a Monthly Planner page for each day of a month or for each month of the year
Sort Selected Todos
Sort Todo boxes by checked/unchecked. Select the paragraphs that have todo checkboxes and run this macro.
Show Month
This macro will insert a month calendar for the specified month. The events are the titles of pages form one or two sections in the same notebook, based on the creation time for the page. A page whose title has a tag will show the tag instead of the time. Each calendar event links to the relevant page.
Outlook Email Date Stamp
This macro will change the creation date of each page in the current section with the time the email was sent, allowing them to be sorted by the email date. This has been made specifically for emails sent to OneNote from Outlook.
Set Notebook Color
Pick a color to set the current notebook color
Tag Complete & Strikethrough
Completes the Todo tag and strikes through the selected paragraph
Custom Rule Lines
Set spacing and color of grid lines to any value.
Capitalize Titles
Capitalizes the first and last word of a selection and any other words longer than 3 letters
TOC in All Notebooks
Creates a new page with table of contents of all notebooks
tOGGLE cASE
Toggle casing of selected text
Search & Replace in Hyperlinks
Search and replace in hyperlink URLs in the current page, section or notebook
Sort Pages Ascending
Sort each page in current section by name in ascending order, sub pages stay under their parent pages and sorted among themselves
Search & Select
Select search terms in the current page
Remove Paragraph and Line Breaks
Removes paragraph breaks and line breaks on selected paragraphs and merges them into a single paragraph
Insert Horizontal Line between Paragraphs
Inserts a horizontal line between each of the selected paragraphs
Insert Time Stamp
Insert YYYYMMDD-HHMMSS
Daily Manager Log
Creates a Daily Manager Log page for each day in the whole year or a month
Insert Subpage With Selected Text As Title
Inserts a new page at the bottom of the section and makes it a subpage and makes the selected text the title. It also creates a link back to the original page.
Clean Authors (Select Scope)
Cleans author information on selected lines, in the current page, section, section group, notebook or all notebooks
TOC in Current Section Group
Creates a new page with table of contents of the current section group
Resize Images by Pixels
Resizes all images image and printouts in the current page to a specified image size.
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.
Tag Complete & Add Date
Completes the todo tag on the selected line and adds the current date/time to the end of it
Insert Page at the Top
Inserts a new page at the top of the current section
Vertical Spacing
This will make all selected content containers equaly spaced away from each other, Enter into the dialog box how much you want the spacing to be.
Title -> Calibri Light 20
Changes title of each page in the current section to Calibri Light 20 to match OneNote 2013 style
Select Done Tasks
Select all done tasks on current page for easy deleting (just hit delete key).
Clean Timestamps
Cleans timestamp information from the current page, typically added by Insert Screen Clipping command
Collapse Parent
Collapse parent outline element
Tag Completion Date
Displays the completion date/time of the To Do tag on the selected paragraph
Search & Tag
Find a search term and create tags in matching paragraphs in the current page, section or notebook
Table to Text
Converts the selected table to text, columns separated by tabs. Preserves formatting but will remove any images
Set Page Date & Time
Set the page date and time to desired time
New Meeting
Insert a small string of text with an automatic date & author. Ideal to start a new meeting.
Collapse Pages in Notebook
Collapse all pages in the current Notebook
Insert legal symbol
Inserts a legal symbol (one of Δ, Π, §, §§, ¶)
Extract highlighted Text
Extracts any highlighted text and prints it at the end of the page
Uncheck All Todos
Uncheck all todo boxes on the current page
Insert Subpages With Selected Paragraphs As Title
Inserts a new page at the bottom of the section for each paragraph selected in the current page, using it as a title
Collapse Pages in Current Section Group
Collapse all pages in the current Section Group
Select Text With Similar Formatting
Selects all the text in the current page with similar formatting to the currently selected text
Move Page to Top of Section
Moves the current page to the top of the section
Prio
This macro is to sort a prioritized To Do list, colors them based on priority and status. You need to select the To Do list to sort them. Indented sections are treated as one, and sorting will not harm them.
Sentence Case
Capitalize the first letter in each sentence in the selected text
Insert Dated Page at the Top
Inserts a new page at the top of the current section with title as date
Sample - Create tables
Creates sample tables in the current page
Collapse Pages in Notebooks
Collapse all pages in all Notebooks
Dim Tags
Dims tags on the current page so that they don't show up in tag search results
Create pages from list of titles
Creates pages in the current section from a given list of titles separated by comma (;)
Rainbow your notebooks and sections
This macro will color all your notebooks and sections as a rainbow. Feel free to enter the macro and modify the color array (also the if statements)
Letter sized paper with infinite length and ruled horizontal lines
Adds a vertical rule line to a letter sized paper with infinite length and ruled horizontal lines. You can change the rule line color afterwards from View > Rule Lines > Rule Line Color if you want.
Shade Alternate Table Rows
Shades alternate rows of selected table to the selected accent color
Go to end of the page
Moves the cursor to the end of the page
List hyperlinks from search in new page (choose scope)
List hyperlinks from search in new page
Recent Edits with Author Info
Displays a summary page of recent edits in current section/section group/notebook or all notebooks with author info that made the edits and date
Undim Tags
Undims tags on the current page so that they show up in tag search results
Page Template Name
Displays the original template used to create the current page
Sort Paragraphs and Remove Duplications
Sort every paragraph on the page exclude empty ones and title. And also delete duplications.
Create sections from list of titles
Creates sections in the current notebook (or section group) from a given list of titles separated by semicolon (;)
Number First Cells
Numbers only the first column in a table starting from a given value.
Copy Current Page to Other Notebooks
Copies current page to other notebooks. Only copies text content. You can select one or more target notebooks, or pick all notebooks.
Sort by Tag
Sort selected paragraphs by their tag name
Transpose Table
Transposes the selected table. It may leave empty cells if the table is not a square. It only works if the table has text. Non-text content will be lost.
Change Text Color
Change color of all instances of text within the given scope that match the given inputs. Required Inputs: hex code of desired color, Scope, Case sensitivity Optional Inputs: Text to Color, Target Font Name, Target Font Size, Various filters NOTE: Either Text to Color or Target Font Size must be provided, both may also be provided for additional specificity.
Sample - Insert Tags
Inserts all possible tags on a new page
Insert Short Date Stamp
Insert "YYMMDD - "
Remove All Indents From All Paragraphs
For every paragraph, it will sent the indent to nothing
Add/Remove Date/Time from Titles
Adds or removes Date/Time from titles of pages in current section or notebook
Capitalize Page Titles
Capitalize titles of pages under selected scope
Sample Insert Text
Inserts text at the current position
Search & Replace in Titles
Search and replace text in titles of pages in selected pages, current section, notebook or all notebooks
Print/SaveAs SimpleHelper - Grid 0.5" on LetterPaper
First, manually apply Letter size w/ margins T&B 0.5" and L&R 1". Then, run this macro to see the "ideal"printable-area if scale-down is not applied. See the comments in Macroland for more information.
Add URL to label of links
For each link in selected scope, adds its URL to the display text
Sample Notebook/Section/Page Picker
Sample macro showing how to allow user pick a notebook, then a section, than a page
Go to the begining of the page
Moves the cursor to the beginning of the page.
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.
Sample - Create a new page
Creates a new page in the current section with given title and some text content
Add Footer to All Pages
Adds the given text to the end of all pages in the current section
Insert Space Between Paragraphs
Inserts an empty paragraph between each of the selected paragraphs
Sample Create Section Hierarchy
Creates a sample section group/section hierarchy
Highlight Hashtags
Highlights hashtags (#word)
Set Container Width manually
Sets the width of all container on the current page to given number of points
Replace Line Breaks with Paragraph Breaks
Replaces line-breaks (inserted with Shift+Enter) with paragraph-breaks in selected text
MultiplyTwoCells
Multiply two cells of a row or a column into a adjoining empty cell in a table
List Password Protected Sections
Lists the password protected sections in the current notebook or all notebooks
Template Litigation Notebook
Creates sections for the LawToolBox Template Litigation Notebook. It is recommended that you create an empty notebook and then run this macro while in that notebook.
Find Table Rows with Search Term
Searches for a term in the current notebook in tables and outputs the found whole table rows into a new page
Make Blank Annual Journal
Select any year between 2013 and 2028 and this macro wil create a Journal for you. Each month is a section, and each month has a page per day, There is also a calendar tab that you can use the "Insert Calendar" macro to fill (I may later extend the macro to do that automatically, and also remove the New Section that is created when you open a new notebook). Future years extensions are a matter of adding a handful of new statements in the macro, but everything in OneNote may have changed by then, so I'll defer that one for now.
Sort Rows by Tag
Sorts the rows of the selected table based on the first tag in the first cell of each row
Sample - Custom Sort Notebooks
Sort notebooks by after the first 6 characters of name
Search & Replace in Section Names
Search and replace text in section names in the current section group, notebook or all notebooks
Collect Clipped URLs
Collect clipped URLs from current section or notebook
Format Numbers
Applies specific formatting to all numbers in the selection or the current page
List pages with a given name
Creates a new page with a list of all the pages in the current notebook that has a certain name
Auto Generate Links to Pages
Automatically creates hyperlinks on any text that matches a page title within the section
Sort Paragraphs by Highlight Color
Sort selected the paragraphs by the highlight color on them. You can use this after using "Extract Highlighted Text" macro to sort the extracted text by highlight color
Color VB Comments
Changes color of text starting with a single quote (') on selected lines to green
Search & Replace in Section Group Names
Search and replace text in section group names in the current notebook or all notebooks
Template SCorpBooks Notebook
Creates sections for the LawToolBox Template SCorpBooks Notebook. It is recommended that you create a new empty notebook and then run this macro while in that notebook.
Sample - Insert Bold Text Then Place Cursor After a Space
Inserts bold text at the current position, then adds a space and places cursor after that
Generate Random String
Generates a random string of 10 characters and inserts it to the current page
Sample - Move Last Row To Top
Sample macro showing how to rearrange rows in a table
Reformat Quick Paste text and URL into a hyperlink (text in BOLD)
Select pasted text name (must be bold) and link from YouTube video name and link, then reformat in only one line reduced format
Set Page Date to Today
Sets the creation date of the current page to current date/time
Copy Plain Text Link to Current Page
Displays the onenote: link for the current page so that you can copy it and paste it into an application that only accepts plain text. Built-in Copy Link to Page feature in OneNote would copy the link in HTML format.
Title -> Times New Roman 20
Changes title of each page in the current section to Times New Roman 20
Font -> Times New Roman 12
Changes selected text font on current page to Times New Roman 12pt
Small-Caps Titles
Capitalizes the first and last word of a selection and any other words longer than 3 letters - all others are set to capitals but 4 sizes smaller to emulate small caps.
Replace Paragraph Breaks with Line Breaks
Replaces paragraph breaks in selected paragraphs with line breaks. Line breaks can be manually inserted using Shift+Enter.
Number Pages
Adds numbering to the page titles in the current section. If the pages already have numbering it will update it
Select Between First two Heading 1
Selects all content between the first and the second Heading 1 styled paragraphs in the current page
Proofing Language -> Portuguese (Standard)
Sets the proofing language on selected text to Portuguese (Standard)
Reformat Quick Paste text and URL into a hyperlink (YT tam18)
Select pasted text (default text size 18) and link from YouTube video name and link, then reformat in only one line reduced format
Green Text
Sets font color to green
Remove Line Breaks
Removes line breaks on selected text
Sample - Insert Styled Paragraph
Inserts a paragraph for each built-in OneNote style into the current page
Insert Page Created Date in ISO format
Inserts the page created date in ISO format (YYYY-MM-DD HH:MM)
Convert "LN, FN" to "FN LN" in Meeting Notes
In meeting notes if there are attendees in the format "LastName, FirstName", this macro converts them to "FirstName LastName" format.
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
Proofing Language -> Slovak (SK)
Sets the proofing language on selected text to Slovak (SK)
Remove Footnote
Removes the selected footnote and associated links
See All Macros