macroland Macroland

Macroland currently has 579 macros by 306 authors

Macros by: Omer Atay

Insert Monthly CalendarCalendar

by Omer Atay, that0n3guy

Inserts a calendar of the selected month and year

Last Updated: April 27, 2019

Sort Pages

Sort

Sort each page in current section by name, sub pages stay under their parent pages and sorted among themselves

TOC in Current Notebook

TOC

Creates a new page with table of contents of the current notebook

Search & Replace

Find

Search and replace text in the current page, section or notebook

TOC in Current Page

TOC

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

Horizontal Line

Inserts a horizontal line

TOC in Current Section

TOC

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

Sort Sections

Sort

Sort each section in current section group by name

Resize Images

Image

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.

Weekly Planner

Calendar

Inserts page with a section for each day in the current week

Sort Pages By Date

Sort

Sorts pages in current section or notebook by created or last modified date

Sort Notebooks

Sort

Sort notebooks by name

Blackboard page

Background

Changes the background color of the page to black, sets all font to white, and optionally removes date/time under title

Function

Table

Use sum, average, etc. functions on tables. Select a cell, a column or a row to apply the functions.

List Notebooks

TOC

Creates a page with a list of all open notebooks and links to them

Search & Highlight

Find

Search and replace text in the current page, section or notebook

Text to Table

Table

Converts selected text into table

Where am I

Navigation

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

Word Count

Info

Displays the number of words and characters on the page

Insert Double Horizontal Line

Horizontal Line

Inserts a double horizontal line

Sort Table

Sort

Sorts selected table by selected column

Tag Summary for Specific Tag

Tags

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

Set Page Background Color

Background

Pick a color to set the page background

Insert Yearly Calendar

Calendar

Inserts a calendar of the selected year

Daily planner Page (Today)

Calendar

Planner with Tasklist and a daily Notes page. This will create a single page with todays date on it.

Recent Edits

History

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

Attachment List

Embedded Files

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

Change Case

Convert selected text to upper case

Set Section Color

Color

Sets Section Color to selected color

Increase Font Size

Font

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

Number of Pages

Info

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

Select Images

Image

Selects all images on the page

Capitalize Each Word

Change Case

Capitalize each word in the selected text

Decrease Font Size

Font

Decreases font size of all text on the page by 1

Sublime Theme

Background

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.

Sort Selected Paragraphs

Sort

Sorts selected paragraphs or list items

Clean Hyperlinks

Content

Removes all friendly hyperlinks in the current page

lower case

Change Case

Convert selected text to lower case

Clean Authors

Content

Cleans author information from the current page

Where am I +

Navigation

Inserts a breadcrumb showing where the current page is in the hieararchy of notebooks / section groups / sections / Parent Pages. Automatic remove the old breadcrumb.

No Spell Check

Spell Check

Removes spell check (red squiggles) from selected text

Tag Summary with Page Names

Tags

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.

Weekly Planner for each day with Done&TODO

Calendar

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

Sort Selected Todos

Sort

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

To-Do List with Page Names

Tags

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

Outlook Email Date Stamp

EMail

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.

Capitalize Titles

Change Case

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

Tag Complete & Strikethrough

Tags

Completes the Todo tag and strikes through the selected paragraph

tOGGLE cASE

Change Case

Toggle casing of selected text

Create Task Cards

Content

Create tasks cards on the page

Diary Pages

Pages

Create Group Section ( Diary 2017)->Create month TAB ( January )->Macro will create diary pages for a given month

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.

Set Notebook Color

Color

Pick a color to set the current notebook color

Insert Subpage With Selected Text As Title

Pages

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.

Remove Paragraph and Line Breaks

Content

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

Show Month

Calendar

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. Each calendar event links to the relevant page

Search & Replace in Hyperlinks

Find

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

Insert Horizontal Line between Paragraphs

Horizontal Line

Inserts a horizontal line between each of the selected paragraphs

Insert Time Stamp

Date/Time

Insert YYYYMMDD-HHMMSS

TOC in All Notebooks

TOC

Creates a new page with table of contents of all notebooks

Sort Pages Ascending

Sort

Sort each page in current section by name in ascending order, sub pages stay under their parent pages and sorted among themselves

Search & Select

Find

Select search terms in the current page

Insert Page at the Top

Pages

Inserts a new page at the top of the current section

Title -> Calibri Light 20

Font

Changes title of each page in the current section to Calibri Light 20 to match OneNote 2013 style

Tag Complete & Add Date

Tags

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

Clean Timestamps

Content

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

Select Done Tasks

Content

Select all done tasks on current page for easy deleting (just hit delete key).

Collapse Parent

Outlining

Collapse parent outline element

Daily Manager Log

Content

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

Tag Completion Date

Tags

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

Resize Images by Pixels

Image

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

Insert legal symbol

Symbols

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

Add icon to page title

Content

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.

Collapse Pages in Notebook

Navigation

Collapse all pages in the current Notebook

Select Text With Similar Formatting

Formatting

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

Vertical Spacing

Containers

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.

TOC in Current Section Group

TOC

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

Set Page Date & Time

Pages

Set the page date and time to desired time

Insert Subpages With Selected Paragraphs As Title

Pages

Inserts a new page at the bottom of the section for each paragraph selected in the current page, using it as a title

Move Page to Top of Section

Page Ordering

Moves the current page to the top of the section

Uncheck All Todos

Tags

Uncheck all todo boxes on the current page

Extract highlighted Text

Text

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

Prio

Sort

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

Pages

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

Search & Tag

Find

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

Dim Tags

Tags

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

Table to Text

Table

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

Custom Rule Lines

Rule Lines

Set spacing and color of grid lines to any value.

Collapse Pages in Notebooks

Navigation

Collapse all pages in all Notebooks

New Meeting

Content

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

Go to end of the page

Navigation

Moves the cursor to the end of the page

Undim Tags

Tags

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

Sample - Create tables

Samples

Creates sample tables in the current page

Page Template Name

Info

Displays the original template used to create the current page

Create pages from list of titles

Pages

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

Recent Edits with Author Info

History

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

Sort Paragraphs and Remove Duplications

Sort

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

Remove All Indents From All Paragraphs

Formatting

For every paragraph, it will sent the indent to nothing

Sentence Case

Change Case

Capitalize the first letter in each sentence in the selected text

Number First Cells

Table

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

Insert Short Date Stamp

Date/Time

Insert "YYMMDD - "

List hyperlinks from search in new page (choose scope)

Find

List hyperlinks from search in new page

Copy Current Page to Other Notebooks

Pages

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

Sort selected paragraphs by their tag name

Print/SaveAs SimpleHelper - Grid 0.5" on LetterPaper

Pages

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.

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.

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.

Sample - Insert Tags

Samples

Inserts all possible tags on a new page

Create sections from list of titles

Sections

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

Sample - Create a new page

Samples

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

Sample Notebook/Section/Page Picker

Samples

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

Sample Insert Text

Samples

Inserts text at the current position

Capitalize Page Titles

Change Case

Capitalize titles of pages under selected scope

Go to the begining of the page

Navigation

Moves the cursor to the beginning of the page.

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.

Shade Alternate Table Rows

Table

Shades alternate rows of selected table to the selected accent color

Add Footer to All Pages

Content

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

Search & Replace in Titles

Find

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

Sample Create Section Hierarchy

Samples

Creates a sample section group/section hierarchy

Replace Line Breaks with Paragraph Breaks

Text

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

Highlight Hashtags

Formatting

Highlights hashtags (#word)

Insert Space Between Paragraphs

Content

Inserts an empty paragraph between each of the selected paragraphs

Change Text Color

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.

Find Table Rows with Search Term

Find

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

Add/Remove Date/Time from Titles

Title

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

List Password Protected Sections

Sections

Lists the password protected sections in the current notebook

Sample - Custom Sort Notebooks

Samples

Sort notebooks by after the first 6 characters of name

Set Container Width manually

Content

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

Collect Clipped URLs

Hyperlink

Collect clipped URLs from current section or notebook

Sort Rows by Tag

Sort

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

Format Numbers

Formatting

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

Sort Paragraphs by Highlight Color

Sort

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

Template Litigation Notebook

LawToolBox

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.

Template Notebook Structure

Templates

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.

Color VB Comments

Formatting

Changes color of text starting with a single quote (') on selected lines to green

MultiplyTwoCells

Table

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

List pages with a given name

Pages

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

Search & Replace in Section Names

Find

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

Proofing Language -> Portuguese (Standard)

Proofing

Sets the proofing language on selected text to Portuguese (Standard)

Reformat Quick Paste text and URL into a hyperlink (text in BOLD)

Content

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 Top

Samples

Sample macro showing how to rearrange rows in a table

Generate Random String

Content

Generates a random string of 10 characters and inserts it to the current page

Search & Replace in Section Group Names

Find

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

Template SCorpBooks Notebook

LawToolBox

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.

Reformat Quick Paste text and URL into a hyperlink (YT tam18)

Content

Select pasted text (default text size 18) and link from YouTube video name and link, then reformat in only one line reduced format

Title -> Times New Roman 20

Font

Changes title of each page in the current section to Times New Roman 20

Sample - Insert Bold Text Then Place Cursor After a Space

Samples

Inserts bold text at the current position, then adds a space and places cursor after that

Select Between First two Heading 1

Content

Selects all content between the first and the second Heading 1 styled paragraphs in the current page

Font -> Times New Roman 12

Font

Changes selected text font on current page to Times New Roman 12pt

Copy Plain Text Link to Current Page

Hyperlink

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.

Replace Paragraph Breaks with Line Breaks

Text

Replaces paragraph breaks in selected paragraphs with line breaks. Line breaks can be manually inserted using Shift+Enter.

Proofing Language -> Slovak (SK)

Proofing

Sets the proofing language on selected text to Slovak (SK)

See macros from other authors