macroland Macroland

Macroland currently has 619 macros by 335 authors
Sort By:

Macros by: Omer Atay

Insert Monthly CalendarCalendar

by Omer Atay, that0n3guy

Inserts a calendar of the selected month and year

Last Updated: October 25, 2020

Sort PagesSort

by Omer Atay, timcurran

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

Last Updated: March 22, 2019

TOC in Current NotebookTOC

by Bosse J W, Omer Atay

Creates or updates table of contents of the current notebook

Last Updated: December 01, 2020

TOC in Current Notebook

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
Line prefix
Collapse
TOC Page Mode
Line prefix '-' : TOC entries are prefixed with a '-' character
Line prefix '§' : entries are prefixed with '§§', '§' and '-' characters
Collapse 'Yes' : All TOC outline levels are collapsed

Search & ReplaceFind

by Omer Atay

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

Last Updated: January 18, 2021

Search & Replace

Find what
Replace with
Scope

TOC in Current PageTOC

by Omer Atay

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.

Last Updated: December 07, 2020

Insert Horizontal Line

Horizontal Line

Inserts a horizontal line

TOC in Current SectionTOC

by Omer Atay

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

Last Updated: April 24, 2018

Weekly PlannerCalendar

by Omer Atay

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

Last Updated: October 02, 2017

Sort SectionsSort

by Omer Atay

Sort each section in current section group by name

Last Updated: August 24, 2017

Sort Sections

Sort direction
Scope

Resize ImagesImage

by Omer Atay, ipotassium, Chris K.Y. FUNG

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.

Last Updated: January 23, 2018

Resize Images

Enter the size of the image as a percentage of the original size (e.g. Enter 50 for 50%), if keepRatio, only width will be used.
Width
Height

Sort Pages By DateSort

by Omer Atay

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

Last Updated: June 25, 2020

Sort Pages By Date

Sort direction
Sort by
Scope

Sort NotebooksSort

by Omer Atay

Sort notebooks by name

Last Updated: July 29, 2017

Sort Notebooks

Sort direction

Blackboard pageBackground

by Omer Atay, Dawn-Marie Oliver

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

Last Updated: February 03, 2018

Blackboard page

Daily Planner Page (Today)

Calendar

Planner with Task List and a Daily Notes page. This will create a single page with today's date on it.

FunctionTable

by Omer Atay

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

Last Updated: April 24, 2018

Function

Select the function to apply to the cells

Word CountInfo

by Omer Atay

Displays the number of words and characters on the page

Last Updated: October 06, 2017

Word Count

Search & HighlightFind

by Omer Atay

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

Last Updated: May 01, 2019

Search & Highlight

Find what
Scope
Color

List Notebooks

TOC

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

Text to Table

Table

Converts selected text into table

Insert Yearly CalendarCalendar

by Omer Atay, that0n3guy

Inserts a calendar of the selected year

Last Updated: May 27, 2020

Insert Yearly Calendar

Year
First Day of Week
One or two columns?
Large Format Day Width
Large Format Day height
Format

Where am I

Navigation

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

Change 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

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

Select Images

Image

Selects all images on the page

Capitalize Each Word

Change Case

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

Font

Decreases font size of all text on the page by 1

lower case

Change Case

Convert selected text to lower case

Sort Selected Paragraphs

Sort

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

Clean Hyperlinks

Content

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

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 +

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.

Clean Authors

Content

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

Tags

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

Change Case

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

Change 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

Remove Paragraph and Line Breaks

Content

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

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

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.

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

Pages

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

Tags

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

Title -> Calibri Light 20

Font

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

Select Done Tasks

Content

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

Content

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

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

Navigation

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

Pages

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

Formatting

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

Uncheck All Todos

Tags

Uncheck all todo boxes on the current page

Collapse Pages in Current Section Group

Navigation

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

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

Collapse Pages in Notebooks

Navigation

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

Samples

Creates sample tables in the current page

Dim Tags

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

Navigation

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

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

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?

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

Formatting

For every paragraph, it will sent the indent to nothing

Insert Short Date Stamp

Date/Time

Insert "YYMMDD - "

Sample - Insert Tags

Samples

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

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.

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

Samples

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

Samples

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

Go to the begining of the page

Navigation

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

Content

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

Samples

Creates a sample section group/section hierarchy

Highlight Hashtags

Formatting

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

Samples

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

Sort

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

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

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

Color VB Comments

Formatting

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

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)

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

Samples

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

Generate Random String

Content

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

Title -> Times New Roman 20

Font

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

Proofing Language -> Portuguese (Standard)

Proofing

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

Copy Plain Text Link to Current PageHyperlink

by Omer Atay

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.

Last Updated: October 03, 2018

Copy Plain Text Link to Current Page

Copy the below link and you can paste it into an application that only accepts plain text Ctrl+C and then hit Esc to close the window

Font -> Times New Roman 12

Font

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

Select Between First two Heading 1

Content

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

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

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.

Set Page Date to Today

Date/Time

Sets the creation date of the current page to current date/time

Small-Caps Titles

Change Case

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.

Green Text

Color

Sets font color to green

Insert Page Created Date in ISO format

Date/Time

Inserts the page created date in ISO format (YYYY-MM-DD HH:MM)

Sample - Insert Styled Paragraph

Samples

Inserts a paragraph for each built-in OneNote style into the current page

Remove Line Breaks

Content

Removes line breaks on selected text

Number Pages

Pages

Adds numbering to the page titles in the current section. If the pages already have numbering it will update it

Convert "LN, FN" to "FN LN" in Meeting Notes

Content

In meeting notes if there are attendees in the format "LastName, FirstName", this macro converts them to "FirstName LastName" format.

Proofing Language -> Slovak (SK)

Proofing

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

See macros from other authors