Macroland

Inserts a breadcrumb showing where the current page is in the hieararchy of notebooks / section groups / sections

Set Page Background ColorBackground

by Omer Atay, JohnZeman

Pick a color to set the page background

Last Updated: May 01, 2019

Set Page Background Color

Color

Insert Double Horizontal Line

Horizontal Line

Inserts a double horizontal line

Weekly Planner for each day with Done&TODOCalendar

by Omer Atay, Xiongyi

Inserts page with a section for each day in the current week with Done, Problem and TODO.

Last Updated: March 04, 2019

Weekly Planner for each day with Done&TODO

Week starts on
	Create checkboxes for each day
Layout
Create weekly planner for
Weeks starting this week
Specific Week

Tag Summary for Specific TagTags

by Omer Atay, neil

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

Last Updated: March 29, 2021

Tag Summary for Specific Tag

Find paragraphs that has all or at least one of the following tags (see option below). Leave Tag 2 and Tag 3 empty if you only want to search for a single tag.
Tag 1
Tag 2
Tag 3
Find paragraphs that have
-------------------------------------------------------------------
Scope
Sort by
Filter

Sort TableSort

by Omer Atay, kugan49

Sorts selected table by selected column

Last Updated: June 20, 2016

Sort Table

Sort direction
Columns

Set Section ColorColor

by Omer Atay

Sets Section Color to selected color

Last Updated: May 01, 2019

Set Section Color

Color

Attachment ListEmbedded Files

by Omer Atay, Chaz Gugino

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.

Last Updated: October 02, 2017

Attachment List

Scope

UPPER CASE

Convert selected text to upper case

Recent EditsHistory

by Omer Atay, Castlevania

Displays a summary page of recent edits in current section/section group/notebook or all notebooks

Last Updated: April 12, 2018

Recent Edits

Scope
Number of Pages to Display

Number of PagesInfo

by Omer Atay, Dave Kiefer

Displays number of pages in current Section/Section Group/Notebook/All Notebooks (Excludes Recycle Bin)

Last Updated: January 18, 2021

Number of Pages

Display number of pages in

Increase Font Size

Increases font size of all text on the page by 1

Auto-fill

Table

Auto-fills selected table cells using data from the first few selected cells

Capitalize Each Word

Capitalize each word in the selected text

Sublime ThemeBackground

by Omer Atay, xjfelix

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.

Last Updated: October 11, 2016

Sublime Theme

Scope

Decrease Font Size

Decreases font size of all text on the page by 1

lower case

Convert selected text to lower case

Sort Selected Paragraphs

Sorts selected paragraphs or list items

To-Do List with Page NamesTags

by Omer Atay, RobertC, Sako73

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)".

Last Updated: August 16, 2018

To-Do List with Page Names

Scope
	Exclude meeting attendance tags

Clean Hyperlinks

Removes all friendly hyperlinks in the current page

Diary PagesPages

by Omer Atay, write2deepaks

Create a page for each day in the selected month with date of the day as the title

Last Updated: November 25, 2020

Diary Pages

Year
Month

Tag Summary with Page NamesTags

by Omer Atay

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.

Last Updated: December 17, 2017

Tag Summary with Page Names

Scope
Filter
	Include section names in the output

No Spell Check

Spell Check

Removes spell check (red squiggles) from selected text

Create Task CardsContent

by Omer Atay

Create tasks cards on the page

Last Updated: November 25, 2016

Create Task Cards

Enter rows x cols to create task cards
Rows
Columns

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

Code mode

Code

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.

Sort Selected TodosSort

by Omer Atay

Sort Todo boxes by checked/unchecked. Select the paragraphs that have todo checkboxes and run this macro.

Last Updated: October 25, 2018

Sort Selected Todos

Sort order

Outlook Email Date StampEMail

by Omer Atay, JasonDaSilva

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.

Last Updated: February 11, 2018

Outlook Email Date Stamp

This Macro will change the page creation date to match the Sent date on the email. This will then allow you to use the Sort by Date macro regardless of when you moved the mail message to OneNote. Email sent date is in a row in the table. The first column says 'Sent' in English, change that based on your language below. The second column has the date, provide the format for the date. This looks something like: ┌──────┬──────────────────────────────────┐ │ Sent │ Friday, February 9, 2018 7:05 PM │ └──────┴──────────────────────────────────┘ Legend for Date Format (examples use values from the date above) Y: 4 digit year (2018) M: 2 digit month (02) D: 2 digit day (09) y: 2 digit year (18) m: 1 or 2 digit month (2) d: 1 or 2 digit day (9) H: 2 digit hour (07) T: 2 digit minute (05) W: Day of the week (Friday) h: 1 or 2 digit hour (7) t: 1 or 2 digit minute (5) N: Month name (February) A: AM or PM (PM) ?: Any 1 character (Useful for things like ?? for -th, -st, -nd, -rd suffixes) For month and day names list short names below if that is the case (Jan,Feb,Mar,...) Also use any other character directly as it appears like comma (,) or space ( ) To get 'Friday, February 9, 2018 7:05 PM', you would need 'W, N d, Y h:T A' as the date format
First column value ('Sent' in English)
Date Format (Use legend above)
Scope
------------------------------------------------------------------------------------------------
Separate values below with comma
Month names (Use short names if they appear as such on the page)
Day names starting Sunday (Use short names if they appear as such on the page)
AM and PM values if applicable

Show MonthCalendar

by Omer Atay, slm

This macro will draw 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 teh dateTime for the page. A page whose title has a tag will show the tag instead of the time. ...

Last Updated: February 27, 2018

Show Month

Month Calendar
Month
Year
Use Section
Also Use Section

Tag Complete & Strikethrough

Completes the Todo tag and strikes through the selected paragraph

Set Notebook ColorColor

by Omer Atay, Chilangosta

Pick a color to set the current notebook color

Last Updated: May 01, 2019

Set Notebook Color

Color

Capitalize Titles

Capitalizes the first and last word of a selection and any other words longer than 3 letters

Monthly Planner PagesContent

by Omer Atay, Guy Shepperd

Creates a Monthly Planner page for each day of a month or for each month of the year

Last Updated: December 14, 2020

Monthly Planner Pages

Enter year and month to generate daily planner logs
Year
Month
Use Font

tOGGLE cASE

Toggle casing of selected text

TOC in All NotebooksTOC

by Omer Atay

Creates a new page with table of contents of all notebooks

Last Updated: December 27, 2016

TOC in All Notebooks

Select link generation mode. In "Resilient" mode links to pages and sections will still work even if they are renamed, however this mode is slow. In "Fast" mode links will no longer work if pages or sections are renamed, but it goes much faster
Link Generation Mode
Scope
TOC Page Mode

Search & Replace in HyperlinksFind

by Omer Atay

Search and replace in hyperlink URLs in the current page, section or notebook

Last Updated: June 12, 2017

Search & Replace in Hyperlinks

Find part of hyperlink
Replace with
Scope
	Match Case

Remove Paragraph and Line Breaks

Removes paragraph breaks and line breaks on selected paragraphs and merges them into a single paragraph

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 & SelectFind

by Omer Atay

Select search terms in the current page

Last Updated: June 20, 2016

Search & Select

Find what

Insert Horizontal Line between Paragraphs

Horizontal Line

Inserts a horizontal line between each of the selected paragraphs

Custom Rule LinesRule Lines

by Omer Atay

Set spacing and color of grid lines to any value.

Last Updated: March 21, 2017

Custom Rule Lines

Check http://html-color-codes.info/ for color codes
Space between horizontal lines (0 for no horizontal lines)
Color for horizontal lines
Space between vertical lines (0 for no vertical lines)
Color for vertical lines
Margin color (leave empty for no margin)

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.

Insert Time Stamp

Date/Time

Insert YYYYMMDD-HHMMSS

Daily Manager LogContent

by Omer Atay

Creates a Daily Manager Log page for each day in the whole year or a month

Last Updated: February 19, 2017

Daily Manager Log

Enter year and month to generate daily manager logs
Year
Month
Title
Subtitle

Clean Authors (Select Scope)Author

by Omer Atay, Howard, DrStrangepork

Cleans author information on selected lines, in the current page, section, section group, notebook or all notebooks

Last Updated: April 26, 2021

Clean Authors (Select Scope)

Scope

TOC in Current Section GroupTOC

by Omer Atay

Creates a new page with table of contents of the current section group

Last Updated: October 02, 2017

TOC in Current Section Group

Select link generation mode. In "Resilient" mode links to pages and sections will still work even if they are renamed, however this mode is slow. In "Fast" mode links will no longer work if pages or sections are renamed, but it goes much faster
Link Generation Mode
Scope
TOC Page Mode

Insert Page at the Top

Inserts a new page at the top of the current section

Add icon to page titleContent

by Omer Atay, John Johnson

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.

Last Updated: February 14, 2019

Add icon to page title

Select an icon to add
Icon:

Tag Complete & Add Date

Completes the todo tag on the selected line and adds the current date/time to the end of it

Resize Images by PixelsImage

by Omer Atay, mufl87

Resizes all images image and printouts in the current page to a specified image size.

Last Updated: October 11, 2016

Resize Images by Pixels

Resize all images and printouts on the current page. Set the final size of the images in pixels. Enter EITHER height or width.
Width
Height
	Selected images only

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).

Vertical SpacingContainers

by Omer Atay, Robert N

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.

Last Updated: January 12, 2019

Vertical Spacing

Enter Gap

Clean Timestamps

Cleans timestamp information from the current page, typically added by Insert Screen Clipping command

Collapse Parent

Outlining

Collapse parent outline element

Tag Completion DateTags

by Omer Atay

Displays the completion date/time of the To Do tag on the selected paragraph

Last Updated: June 20, 2016

Tag Completion Date

This To Do tag was checked at:
~ value decided at runtime ~

Search & TagFind

by Omer Atay

Find a search term and create tags in matching paragraphs in the current page, section or notebook

Last Updated: September 30, 2016

Search & Tag

Find what
Tag
Scope
	Add tag as completed or complete exising tag
	Match case

Insert legal symbolSymbols

by Omer Atay

Inserts a legal symbol (one of Δ, Π, §, §§, ¶)

Last Updated: June 20, 2016

Insert legal symbol

Choose Symbol

Set Page Date & TimePages

by Omer Atay

Set the page date and time to desired time

Last Updated: July 02, 2017

Set Page Date & Time

Scope
Enter new date (YYYY-MM-DD)
Enter new time (HH:MM). Use 24 hour format

Collapse Pages in Notebook

Collapse all pages in the current Notebook

Table to Text

Table

Converts the selected table to text, columns separated by tabs. Preserves formatting but will remove any images

Extract highlighted TextText

by Omer Atay, ralphkurz

Extracts any highlighted text and prints it at the end of the page

Last Updated: June 12, 2017

Extract highlighted Text

Select the scope for finding highlighted text. If Current Page is not selected, the results will be displayed on a new page
Scope

New MeetingContent

by Omer Atay, Chris Van de Voorde

Insert a small string of text with an automatic date & author. Ideal to start a new meeting.

Last Updated: February 09, 2020

New Meeting

Enter the person you are meeting with and subject
Meeting With
Meeting Subject

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

Select Text With Similar Formatting

Selects all the text in the current page with similar formatting to the currently selected text

Uncheck All Todos

Uncheck all todo boxes on the current page

Collapse Pages in Current Section Group

Collapse all pages in the current Section Group

Move Page to Top of Section

Page Ordering

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.

Insert Dated Page at the Top

Inserts a new page at the top of the current section with title as date

Collapse Pages in Notebooks

Collapse all pages in all Notebooks

Sentence CaseChange Case

by Omer Atay

Capitalize the first letter in each sentence in the selected text

Last Updated: December 01, 2020

Sentence Case

Choose an option

Sample - Create tables

Creates sample tables in the current page

Dim Tags

Dims tags on the current page so that they don't show up in tag search results

Create pages from list of titlesPages

by Omer Atay

Creates pages in the current section from a given list of titles separated by comma (;)

Last Updated: April 06, 2017

Create pages from list of titles

Enter page titles, separated by commas
Page Titles

Go to end of the page

Moves the cursor to the end of the page

Letter sized paper with infinite length and ruled horizontal lines

Rule 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 RowsTable

by Omer Atay

Shades alternate rows of selected table to the selected accent color

Last Updated: April 19, 2019

Undim Tags

Undims tags on the current page so that they show up in tag search results

Recent Edits with Author InfoHistory

by Omer Atay

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

Last Updated: May 15, 2017

Recent Edits with Author Info

Scope
Edits Since (Enter in YYYY-MM-DD format)

Page Template NameInfo

by Omer Atay

Displays the original template used to create the current page

Last Updated: June 20, 2016

Page Template Name

~ value decided at runtime ~

List hyperlinks from search in new page (choose scope)Find

by Omer Atay, martyh1

List hyperlinks from search in new page

Last Updated: October 26, 2018

List hyperlinks from search in new page (choose scope)

Search term
Find in
Scope
	Match case

Sort Paragraphs and Remove DuplicationsSort

by Omer Atay, kolokolok

Sort every paragraph on the page exclude empty ones and title. And also delete duplications.

Last Updated: December 05, 2018

Sort Paragraphs and Remove Duplications

Sort Direction

Copy Current Page to Other NotebooksPages

by Omer Atay

Copies current page to other notebooks. Only copies text content. You can select one or more target notebooks, or pick all notebooks.

Last Updated: March 17, 2019

Copy Current Page to Other Notebooks

Do you want to copy current page to All Notebooks or to a set of Selected Notebooks?

Rainbow your notebooks and sections

Color

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)

Number First CellsTable

by Omer Atay, Massimo

Numbers only the first column in a table starting from a given value.

Last Updated: May 23, 2017

Number First Cells

Please enter a starting number.
How much should it go up each time?
	Skip first row

Create sections from list of titlesSections

by Omer Atay

Creates sections in the current notebook (or section group) from a given list of titles separated by semicolon (;)

Last Updated: August 21, 2017

Create sections from list of titles

Enter section names, separated by semicolons (;). Names must be unique.
Section Names

Sort by TagSort

by Omer Atay

Sort selected paragraphs by their tag name

Last Updated: August 03, 2017

Sort by Tag

Select scope
Scope
Sorting Option

Remove All Indents From All Paragraphs

For every paragraph, it will sent the indent to nothing

Insert Short Date Stamp

Date/Time

Insert "YYMMDD - "

Sample - Insert Tags

Inserts all possible tags on a new page

Transpose Table

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.

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.

Change Text ColorColor

by OmnesPotens, Omer Atay

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...

Last Updated: April 07, 2018

Change Text Color

Target Text to Color
Desired Color
Target Font Name
Target Font Size
Scope
	Match case
	Filter: is bolded
	Filter: is italicized
	Filter: has underline
	Filter: has strikethrough
See: https://www.w3schools.com/colors/colors_picker.asp

Add/Remove Date/Time from TitlesTitle

by Omer Atay

Adds or removes Date/Time from titles of pages in current section or notebook

Last Updated: September 06, 2019

Add/Remove Date/Time from Titles

Scope
Add/Remove

Capitalize Page TitlesChange Case

by Omer Atay

Capitalize titles of pages under selected scope

Last Updated: July 02, 2017

Capitalize Page Titles

Scope

Sample Insert Text

Inserts text at the current position

Sample Notebook/Section/Page PickerSamples

by Omer Atay

Sample macro showing how to allow user pick a notebook, then a section, than a page

Last Updated: July 31, 2016

Sample Notebook/Section/Page Picker

Select a notebook
Notebook

Sample - Create a new page

Creates a new page in the current section with given title and some text content

Search & Replace in TitlesFind

by Omer Atay

Search and replace text in titles of pages in selected pages, current section, notebook or all notebooks

Last Updated: August 16, 2017

Search & Replace in Titles

Find what
Replace with
Scope
	Match case

Go to the begining of the page

Moves the cursor to the beginning of the page.

Add Footer to All PagesContent

by Omer Atay

Adds the given text to the end of all pages in the current section

Last Updated: May 23, 2017

Add Footer to All Pages

Enter footer text to add to the pages
Line 1
Line 2 (optional)
Line 3 (optional)

Insert Space Between Paragraphs

Inserts an empty paragraph between each of the selected paragraphs

Template Notebook StructureTemplates

by Omer Atay

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.

Last Updated: December 02, 2018

Sample Create Section Hierarchy

Creates a sample section group/section hierarchy

Highlight Hashtags

Highlights hashtags (#word)

Replace Line Breaks with Paragraph Breaks

Text

Replaces line-breaks (inserted with Shift+Enter) with paragraph-breaks in selected text

Set Container Width manuallyContent

by Omer Atay, peace_of_mind

Sets the width of all container on the current page to given number of points

Last Updated: April 11, 2019

Set Container Width manually

Enter Container width

Fix Printout RedX Issue

Workarounds

Worksaround a bug in OneNote 2016 where prinouts will show up as red X on other clients. This macro runs on current notebook and fixes all such pages.

List Password Protected SectionsSections

by Omer Atay

Lists the password protected sections in the current notebook or all notebooks

Last Updated: March 31, 2020

List Password Protected Sections

Scope

MultiplyTwoCellsTable

by Omer Atay, Rajguru

Multiply two cells of a row or a column into a adjoining empty cell in a table

Last Updated: June 14, 2018

MultiplyTwoCells

Please select cell(s) from a single table

Find Table Rows with Search TermFind

by Omer Atay

Searches for a term in the current notebook in tables and outputs the found whole table rows into a new page

Last Updated: October 24, 2016

Find Table Rows with Search Term

Enter text to search for table rows

Sample - Custom Sort Notebooks

Sort notebooks by after the first 6 characters of name

Template Litigation NotebookLawToolBox

by Omer Atay

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.

Last Updated: February 21, 2018

Template Litigation Notebook

This macro will create 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. Click OK to continue, or close this message to stop

Sort Rows by Tag

Sorts the rows of the selected table based on the first tag in the first cell of each row

Collect Clipped URLsHyperlink

by Omer Atay

Collect clipped URLs from current section or notebook

Last Updated: November 15, 2016

Collect Clipped URLs

Search for hyperlinks on paragraphs that
start with
in

Format NumbersFormatting

by Omer Atay

Applies specific formatting to all numbers in the selection or the current page

Last Updated: June 11, 2017

Format Numbers

Scope
Formatting
	bold
	italic
	underline
	superscript
	subscript
	highlight

List pages with a given namePages

by Omer Atay

Creates a new page with a list of all the pages in the current notebook that has a certain name

Last Updated: January 13, 2018

List pages with a given name

Enter the page name to find
Name

Search & Replace in Section NamesFind

by Omer Atay

Search and replace text in section names in the current section group, notebook or all notebooks

Last Updated: December 17, 2017

Search & Replace in Section Names

Find what
Replace with
Scope
	Match case

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 NamesFind

by Omer Atay

Search and replace text in section group names in the current notebook or all notebooks

Last Updated: December 17, 2017

Search & Replace in Section Group Names

Find what
Replace with
Scope
	Match case

Template SCorpBooks NotebookLawToolBox

by Omer Atay

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.

Last Updated: February 21, 2018

Template SCorpBooks Notebook

This macro will create sections for the LawToolBox Template SCorpBooks Notebook. It is recommended that you create an empty notebook and then run this macro while in that notebook. Click OK to continue, or close this message to stop.

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

Sample - Move Last Row To TopSamples

by Omer Atay

Sample macro showing how to rearrange rows in a table

Last Updated: November 25, 2016

Sample - Move Last Row To Top

Please select a table for this macro

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

Title -> Times New Roman 20