macroland Macroland

Macroland currently has 392 macros by 203 authors

Most Popular

Insert Monthly Calendar

by Omer Atay, that0n3guy

(12)41582 Downloads

Inserts a calendar of the selected month and year

Last Updated: July 25, 2017

Sort Pages

(5)39059

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

TOC in Current Notebook

(10)34893

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

TOC in Current Section

(7)23401

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

Insert Horizontal Line

(9)23348

Inserts a horizontal line

TOC in Current Page

(10)20878

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.

Less Popular

Sort Sections

by Omer Atay

(1)17316 Downloads

Sort each section in current section group by name

Last Updated: May 23, 2017

Sort Sections

Sort direction

Search & Replace

(10)17021

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

Sort Pages By Date

(3)14985

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

Sort Notebooks

(2)11258

Sort notebooks by name

Blackboard page

(6)10357

Make the background color of the page black.

List Notebooks

(4)9979

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

Resize Images

(5)9960

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.

Insert Double Horizontal Line

(7)9835

Inserts a double horizontal line

Sort Pages By Date +

(2)9736

Sorts pages in current section by created or last modified date. The page-subpage hierarchy won't be lost because subpages will move along with their higher level pages.

Where am I

(4)9688

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

Sort Table

(3)8471

Sorts selected table by selected column

Recent Edits

(4)7844

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

Text to Table

(2)7811

Converts selected text into table

UPPER CASE

(4)7356

Convert selected text to upper case

Word Count

(8)7274

Displays the number of words and characters on the page

Tag Summary for Specific Tag

(2)7026

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

Weekly Planner

(1)6988

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

Capitalize Each Word

(3)6520

Capitalize each word in the selected text

Function

(1)6147

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

Attachment List in Current Notebook

(1)6117

Creates a list of attachment filenames in current notebook. Updated to provide page names and links back to the page and the embedded files.

Background Color List

(1)5951

This macro gives you several options for setting the current page background color. Choose from a drop down list of colors that's loosely based on standard HTML color names, or you can set the page to any custom background color by entering its hex triplet value.

Insert Date Created or Completed

(2)5836

Insert "Created:" or "Completed:" and today's date at the cursor position. Does not work if cursor is next to or in a hyperlink.

lower case

(3)5600

Convert selected text to lower case

Sort Selected Paragraphs

(2)5528

Sorts selected paragraphs or list items

Search & Highlight

(2)5527

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

Number of Pages

(2)5373

Displays number of pages in current Section/Section Group/Notebook/All Notebooks

Set Section Color

(2)4874

Sets Section Color to selected color

Sort Selected Todos

(2)4567

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

Where am I +

(3)4405

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

Set All Pictures as Background

(2)4381

This macro sets all images on the page to a background image, usefull for large printouts

Perfect Printouts

(0)4303

Puts printouts on the left, butted vertically, inserts slide number to the right of the upper right corner in the current font and sets the images as background.

No Spell Check

(4)4281

Removes spell check (red squiggles) from selected text

Search Multi-Keywords

(5)4268

Search the paragraphs containing all the multiple keywords within a scope, and create a new page reporting the search results in the current section. Use semicolons (;) to separate the keywords, e.g. keyword1;keyword2;keyword3. There is (theoretically) no limit to the maximum number of keywords. But the speed is optimized for searching three keywords, and it slows down when more than three keywords are used. There are five opinions of scopes available, namely, “Current Page”, “Selection”, “Current Selection”, “Current Notebook”, and “All Notebooks”. It can take a long time, if search in notebook(s). Skip function is available, that is mainly for excluding pages that contain the previous search reports, to avoid duplicating the search results. Skip can take place in all scopes except the “Current Page” opinion. Change the texts as if you desired. It will skip the pages if their names contain the defined string. The report page lists the matched paragraphs and where they are found in.

Sublime Theme

(1)4227

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.

Word Count - Selected

(4)4102

Displays the number of words and characters in the selected region - Credit to original Word Count by Omer Atay

Insert Long Date

(1)4082

Insert long-format date

tOGGLE cASE

(4)3969

Toggle casing of selected text

Capitalize Titles

(4)3921

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

Tag Summary with Page Names

(1)3796

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.

Set Column Widths

(4)3713

Sets the column width of the selected table on the current page to the specified value.

Tag Complete & Strikethrough

(2)3697

Completes the Todo tag and strikes through the selected paragraph

Increase Font Size

(1)3577

Increases font size of all text on the page by 1

Indent Paragraphs

(1)3374

Indents the first line of each paragraph on the current page to make it more readable. It can also remove the indentation if Remove option is selected.

Outlook Email Date Stamp

(2)3372

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.

Show uncompleted to dos

(0)3311

Reveals uncompleted to dos that are hidden by collapsed paragraphs. Useful for hierarchical task management.

Set Proofing Language

(3)3308

Prompt user to set proofing language on selected text.

Expand/Collapse Outlines

(1)3266

Toggle Expand/Collapse, or expand to the selected outlines to the chosen level (Level 1 to 9 as well as all levels).

Clean Authors (Select Scope)

(1)3221

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

Auto-fill

(2)3201

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

Column Widths+

(2)3199

Sets the width of selected or all column(s) of the selected table on the current page to the specified value.

Insert Subpage With Selected Text As Title

(1)3192

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.

Apple

(1)2981

Make the background color of the green, more color than default apple color

Remove Paragraph Breaks

(3)2958

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

Color Sections by Section

(2)2927

Color all Sections in current SectionGroup by the current Section color

Decrease Font Size

(1)2906

Decreases font size of all text on the page by 1

Insert Horizontal Line between Paragraphs

(0)2886

Inserts a horizontal line between each of the selected paragraphs

Programmer (Sensitive Eyes)

(0)2840

This changes the following on the active page: Background Color, Body Font Color, Title Font Color, Header Colors, and Hyperlink colors. The theme is a light programmable theme for people with sensitive eyes.

Set Page Font

(1)2834

Sets the whole page to 1 specific font.

Select Images

(1)2816

Selects all images on the page

Sort Tags

(1)2756

Sort items by whether they are complete or not.

Collapse Pages

(2)2695

Collapse all Pages in the current Section

Insert Yearly Calendar

(2)2669

Inserts a calendar of the selected year

Title -> Calibri Light 20

(1)2645

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

Insert Page at the Top

(1)2475

Inserts a new page at the top of the current section

Clean Timestamps

(1)2468

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

Collapse Parent

(2)2458

Collapse parent outline element

Fit printout images to Letter template - for entire section

(0)2405

If you import an 8.5x11 page from a printout (Ex. from a PDF) into OneNote, this macro will fit the image to the size of the Letter template and also set the image to background, making it ready to annonate and easily print out to paper if necessary. Note that this will only work when using the Letter template included in OneNote. This macro will apply the change across all pages in the current section, for when the imported printout's pages are spread across multiple subpages in OneNote.

Search & Replace in Hyperlinks

(2)2392

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

Resize and space

(3)2374

Resizes images and printouts and spaces them out by the specified amount. Useful for slide images.

Set Notebook Color

(1)2372

Changes notebook color to hexadecimal value.

Teal

(1)2235

Make the background color of the page Teal, higher satuartion and more color than default teal

Team Activity Tracker

(2)2230

We use OneNote as an activity tracker for my small team of IT Support techs. Each day has its own page, with a table for tracking our work. Each month is its own section, and each year is a section group. This Macro allows me to create an entire year's worth of blank pages in about 5 minutes. I know there's more that could be done to improve it, but I havent the time. Feel free to use or edit this in any way that suits you. Thanks to Omer for a fantastic product, and great support!

Insert Time Stamp

(0)2200

Insert YYYYMMDD-HHMMSS

Search & Select

(1)2066

Select search terms in the current page

Insert legal symbol

(2)2062

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

Select Done Tasks

(0)2061

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

Clean Hyperlinks

(3)2023

Removes all friendly hyperlinks in the current page

Tag Completion Date

(1)1969

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

Insert DD Month YYYY

(1)1948

Insert DD Month YYYY

Programmer (Wombat)

(0)1936

This changes the following on the active page: Background Color, Body Font Color, Title Font Color, Header Colors, and Hyperlink colors. The theme is a dark programmable theme similar to Wombat.

Font -> Calibri

(1)1907

Changes text font on current page to Calibri to match OneNote 2013's style (useful for pasted text)

Extract segment

(2)1888

Creates a new page from a selected segment, using the first line as the title

Select Text With Similar Formatting

(2)1855

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

Insert Subpages With Selected Paragraphs As Title

(2)1731

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

Customize the Title

(0)1725

This macro is intended to show how to customize the title. You have to select the first paragraph in the current page and replace the text

Clean Authors

(2)1705

Cleans author information from the current page

Clear Cells

(1)1682

Delete text from selected cells

Tag Complete & Add Date

(0)1671

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

Sort Table (optional header)

(0)1651

Sorts selected table by selected column. Has an option to exclude header.

Insert Time Last Modified

(3)1611

Inserts the last modified date/time as MM/DD/YY HH:MMpm for each outline in the current page

Collapse Pages in Notebook

(0)1593

Collapse all pages in the current Notebook

Move Page to Top of Section

(2)1561

Moves the current page to the top of the section

Color (Select Scope)

(2)1552

Color in the current section group, notebook or all notebooks, based on the current section.

Insert Subpage

(0)1535

inserts a new page at the bottom of the section and makes it a subpage

Columns Width of Selected Table

(0)1531

Use this macro to set the same columns-width for the selected table/s. To make a single table selected, just click a cell of it

Lemon

(1)1528

Makes background Yellow, brighter than default Lemon color

Dim Tags

(1)1488

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

Set rule lines on/off in scope

(0)1485

Enables or disables rule linese in given scope

Sort Pages Ascending

(0)1469

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

Add link

(1)1424

ADD A LINK-TO-ORIGINAL-FILE THAT IS MISSING Procedure: 1-Shift + right click on the file 2-Choose Copy as Path 3-Go to OneNote, Onetastic Link > Add Link (the macro) 4-Paste it in the box with Ctrl+V

Uncheck All Todos

(3)1389

Uncheck all todo boxes on the current page

Insert Time Stamp ISO

(0)1356

Insert YYYY-MM-DD HH:MM:SS

Purple

(1)1344

Make the background color of the page purple, fuller color than default purple

Grey Rulelines for Black Pages (Page)

(0)1334

Toggles rule lines on and off for current page, sets color to dark grey, and style to small grid (made for blackboard and dark windows themes)

Tag Summary for Specific Tag with Page Name

(0)1333

Creates a tag summary page for a specific tag with Page Name

Collapse Pages in SectionGroup

(0)1317

Collapse all pages in the current SectionGroup

Resize Images by Pixels

(2)1304

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

Insert Comment

(1)1304

Insert a comment by the current author at the end of the current paragraph

Undo No spell check

(0)1282

Undoes "No spell check" macro. This allows OneNote to display spell check (red squiggles) in selected text if one has previously disabled this feature through the "No spell check" macro.

Black Theme

(0)1265

Makes the background color of all the pages in a Section Black and converts existing text to white

BG: Blue

(1)1263

Highlights a text blue.

Undim Tags

(1)1256

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

Expand Pages

(0)1251

To expand pages

Set Page Date & Time

(1)1246

Set the page date and time to desired time

Reference Pages in this Section

(1)1234

References are added to Pages in this section (case-sensitive)

Prepend Creation to Title

(2)1230

Prepends create date *yyyy-mm-dd* to tite if it does not exist

Sort All Paragraphs

(0)1225

Sort all paragraphs on the page and optionally empty duplications

Align Left

(2)1203

Left align all selected outlines with the first one. You may wan to to add an empty outline on Top of the page before executing the macro to set a specific position.

TOC in All Notebooks

(0)1198

Creates a new page with table of contents of all notebooks

Add @Context

(0)1193

In function of the Todo.txt concept, add a context to all tags that have the name "Takenlijst" in the Dutch OneNote. In English it must be "To Do" I think so you'd have to correct it in this macro. Contexts are defined in the Prompt-function so you'd have to adjust it to your likings.

Extract highlighted Text

(1)1191

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

Insert Dated Page at the Top

(1)1186

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

Go to end of the page

(1)1170

Moves the cursor to the end of the page

Create a title for the page

(0)1164

The titel is in form of yyyymmdd - and free text of titel (for e.g. "20141016 - Test the best")

Outlook FROM SubPager

(1)1162

Creates header pages for each sender, then sorts and sets emails as subpages under the header pages. Running it a second time removes the subpaging, sorts by name, but cannot remove the header pages. These are renamed 0000DeleteMe for easy removal. This tool is for use with emails that were sent to OneNote specifically from Outlook. It may not work with exports/prints from other mail clients. Updated Jan 2017

Un/Complete Tasks

(1)1134

Strikes through all tasks set as done (in entire page) and adds current date & time (greyed) to their end to signify when they were completed. Does the reverse on tasks that aren't done, to automatically reset a task and remove strike/date.

Table to Matrix

(1)1134

Convert a table into a matrix string, which represents a matrix in equation editor. To display as matrix, select the result string and press Alt+"=" to make it an equation and then switch it from "linear format" to "professional format".

Zotero References

(2)1130

Copy the all the zotero reference to the end of the current page.

Clean Authors From Section

(1)1115

Cleans author information from all pages in the current section

Create Task Cards

(1)1109

Create tasks cards on the page

Dark Ruled Lines for Black Pages

(1)1108

Sets color to a dark grey for a black background

Prio

(0)1107

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.

Proofing Language Page -> English (US)

(2)1101

Sets the proofing language on selected page to English (US)

Diary Pages

(1)1077

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

Show Month

(0)1066

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

Proofing Language Text -> English (UK)

(2)1061

Sets the proofing language on selected text to English (UK)

Platinum

(0)1058

Make the background color of the page #E5E4E2 (RGB: 229, 228, 226 - HSL: 0.11, 0.05, 0.89)

Collapse Pages in Notebooks

(0)1038

Collapse all pages in all Notebooks

Toggle Complete/Strikethrough and Sort

(1)1014

Toggles the Todo tag Complete/Incomplete and Strikethrough of the selected paragraph. Then, sorts completed items at the bottom. This is a combonation of two existing macros.

Number Cells

(0)1014

Numbers all the cells in a table starting from a given value.

Page Template Name

(1)1002

Displays the original template used to create the current page

Collapse All Parents

(0)996

Collapse all parent outline elements (based on the macro Collapse Parents but does it on the parents of the parents and so on)

中英样式

(1)987

一键分别设置整个page为 英文字体14/Arial、中文14/微软雅黑,颜色黑,另外可在宏编辑器中修改以自定义喜欢的样式,已解决英文被onenote识别为中文的问题

TOC in Current Subpages

(0)973

Creates a table of contents of the current page subpages

Content Map in Current Page

(0)959

Add a compact, mind map style table of contents to the top of the current page. The table of contents is limited to 3 heading levels. The connector lines between nodes are 'drawn' using special glyphs from a monospace font. To minimize user interaction, no UI is displayed.

Set images not as background

(3)953

Sets all images as not background.

Tag Incomplete

(0)938

Marks the Todo tag Incomplete and clears strikethrough of the selected paragraph.

Content Map in Current Section

(1)925

Add a compact, mind map style TOC tree at the top of the current section. The tree contains links to all section pages and up three levels of headings per page. The connector lines between nodes are 'drawn' using special glyphs from a monospace font. To minimize user interaction, no UI is displayed.

Code mode

(2)920

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.

Shift all images up and left

(0)906

Shift all images up to the top left corner of the page (useful if you hate the top margin made by default with printouts)

Align and Space

(0)901

Left-aligns and vertically spaces the selected outlines. Change the padding value to control spacing between outlines.

Set All Pages In Section Color

(0)897

Sets All Pages in selected Section color

Search & Bold

(0)896

Bold search terms in the current page

Completed tags - grey out, checked date

(1)878

Grey out completed tags and write date when it was completed

Add Comment

(0)877

Add comments to selected text. The selected text is highlighted with a color picked from a built-in pallette. Comments are put into their own section on the right of the commented text and marked with the same highlight color.

Clean Hyperlinks and HTML spaces

(0)867

Removes all friendly hyperlinks in the current page and any "&"nbsp";" that may subsequently appear. Many thanks to omeratay for both the original hyperlink macro and the software environment in which generate macros!

Search & Spell Check Off

(2)865

Turn spell check off for matching text. Useful to programmers to get rid of spell check errors for technical terms you do not want to add to the custom dictionary. Examples of such terms are camel case words used for XML tag, type or function names.

Move empty pages to end of section

(0)825

Moves empty pages to end of section. (Caveat: this will identify pages without text as empty, so be sure to inspect each one of them before deleting them!)

全页字体微软雅黑

(0)820

Changes text font on current page to Microsoft Yahei (for Chinese typing, refers to macro'Font -> Calibri')

All Section Font Calibri Light

(0)791

All fonts change to Calibri Light, Titles to Font Size 20

Perfect Printouts II

(0)776

Puts printouts on the left against the margin line and removes the vertical gap between each page/slide. Pages/slides are not given numbers and not turned into part of the background.

Title -> Calibri Light 20 (Current page only)

(0)766

Changes title of current page to Calibri Light 20 to match OneNote 2013 style

Insert Short Month Date

(0)766

Insert short month format date

FG: White

(0)764

Colors a text in white.

Matrix to Table

(0)761

Convert a matrix into a table. To use this macro, you need first change your matrix into plain text by using Alt+"=".

Sort Pages in all Sections in Notebook

(0)759

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

New Website

(0)750

Create a predifine structure for current Webpage

HTML Space

(0)748

Replace the HTML space character "&nbsp" with a space " ". Helpful following use of hyperlink removal macro.

Tag Started and Completed

(1)734

When run once on a todo item, records the time started at the beginning. When run a second time, replaces the start time with the time elapsed since the tag and the current time and tags the item as completed. Known bugs: the cursor may jump around. Does not validate that the text after "- started at" is correct.

Remove All Indents From All Paragraphs

(0)728

For every paragraph, it will sent the indent to nothing

Insert Day and Date

(0)727

Insert DD Day

Vehicle Auction_Spaced

(0)716

A new vehicle auction

Custom Theme

(0)710

apply your theme. please edit macro.

Add URL to label of links

(0)705

Take each link and add its URL to the displayed text

设置默认格式

(2)680

设置段落的默认字体为10.5,字体为微软雅黑

Insert SubPage with Data as Title

(0)680

Insert subpage at the end of the section and set date as a name of the page.

Bring selected stacked image to front

(0)672

Simple macro using z property - useful for stacked offset images

All Page Font Calibri Size 11

(1)655

All fonts change to Calibri black size 11, Titles to Font Size 20. 1 page effect

Align Left

(1)654

Aligns Left all selected containers to the topmost selected one

Replace Page Title with Text Selection

(0)648

Replaces current page title with selection; if no text selected leaves page title unchanged

Dim Selected Tags

(1)640

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

Sort Completed

(0)638

Sorts all todo lists on the page by completed status.

Number Selected Cells

(0)627

Set numbers from 1 to n to the sellected Cells

Insert Short Date Stamp

(0)622

Insert "YYMMDD - "

Mark All Pages as Read

(0)613

This will mark each page in the current Section as Read

Sort each paragraph on the page Ascending

(0)607

Exclude empty paragraph and title and no selection needed.

Clean External Hyperlinks

(0)600

Removes all external hyperlinks, leaving internal and files intact

Insert Page at the Top with Short Date as Title

(0)599

Inserts a new page at the top of the current page stack and sets a short date as a page name

Zotero Link in form of Author, Year

(1)596

Convert each Quick Copy of Zotero Scanable Cite { | Author, Year | | |zotero://select/items/#_########} on the current page to a text in form of "Author, Year" with a hyperlink linked to Zotero. Each cite must in an individual paragraph.

Sort paragraphs and Empty Duplications

(0)595

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

Print/SaveAs SimpleHelper - Grid 0.5" on LetterPaper

(0)583

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

Custom Grid Lines

(1)577

Set spacing and color of grid lines to any value.

Proofing Language Text -> English (US)

(0)569

Sets the proofing language on selected text to English (US)

Toggle Red/Black

(0)566

Toggles selected text between red and black font colour.

Daily Manager Log

(2)565

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

Create Page With Completed Tag Summary

(0)556

Creates a tag summary page at the end of the section(s) selected for all completed tags. The page name that the tag was on is included in the summary list.

Reset Stacked Image Order

(0)534

Select all images on the page & put in the original order

Number Cells in a Specific Column

(0)533

Numbers the cells in a specific column in the Table. If there is data in this column it will be overwritten with the number

Font -> Courier New 9

(0)527

Changes selected text font on current page to Courier New and font size 9 to indicate code parts

Table to Text

(2)518

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

Veritical Spacing

(1)513

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.

Search & Tag

(3)496

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

Number First Cells

(1)494

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

Insert User Comment

(0)494

Insert a Text comment highlighted at end of current paragraph with author's initials

Grey Out & Strike Through Completed

(0)489

Grey out and strike through completed tags

Set label of links to URL

(0)485

Take each link and set its displayed text to the URL

Grey out completed

(0)482

Grey out completed tags and write date when it was completed

Selected text --> Calibri 12 Black

(0)480

Changes selected text font to Calibri size 12 black

Reformat Quick Paste text and URL into a hyperlink

(0)477

Select pasted text and link from a web page, then run a macro - the URL will be added as a Hyperlink to the text.

Clone Hyperlinks

(0)476

Clone Hyperlinks Across Same Texts in Current Page. Find each text with hyperlink, and then clone the hyperlink to the same texts in Current Page. Last updated: 2015-01-01 (fixed bugs)

Sample - Create tables

(1)471

Creates sample tables in the current page

Super Color

(1)471

You can change all colors Onenote, it is recommended with Snipaste practical, / 可以改Onenote所有颜色,建议搭配Snipaste使用,.

Insert Horizontal Line (A4)

(0)469

Inserts a horizontal line adjusted for notes (A4)

Sample Notebook/Section/Page Picker

(1)464

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

Toggle Complete/Strikethrough

(0)459

Toggles the Todo tag Complete/Incomplete and Strikethrough of the selected paragraph.

Add link and rename URL text to display

(0)458

ADD A LINK-TO-ORIGINAL-FILE THAT IS MISSING Procedure: 1-Shift + right click on the file; 2-Choose Copy as Path; 3-Go to OneNote, Onetastic Link > Add Link (the macro); 4-Paste it in the box with Ctrl+V; 5-Type a custom document name or Paste the URL and modify it to your linking

Annotate

(1)457

Hightlight selected text and insert comment about the text into a new tag. Comments will be visible when you hover the cursor over the tag symbol.

Scale

(0)456

Inserts fixed-font 80 point scale

Next Unfinished To-Do Item

(0)455

Selects the next unfinished to-do item in the current page. The search starts after the current cursor location. Otherwise selects the first unfinished to-do item on the page.

White Theme

(0)449

To reset theme to defaults which is white background with black font colour, this macro is very useful if you are unable to undo changes of custom theme such as black theme, etc

Add some BBcode tags

(0)448

Adds BBcode [u][/u] [i][/i] and [b][/b] tags to underlined, italics, and bold text for copy/pasting into various places on the web. May not work across paragraphs. Preserves original formatting.

Transpose Table

(0)445

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.

Copy text to first Page

(0)443

This will copy all of the text from a page (and title) to the bottom of the first page in the same section. It will not copy images etc. it is a rough way to merge text pages from the bottom up. Please improve!

To-Do List with Page Names

(0)443

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

Input Font (Select Scope)

(0)434

Change text and title font in the current page, section, section group, notebook or all notebooks. Size to text is 11 and title is 20.

Horizontal Spacing

(1)433

This will make all selected content containers equaly spaced horizontaly away from each other (starting with topmost container), Enter into the dialog box how much you want the spacing to be.

Task Count + Tags

(0)431

Modified version of Task Count by Dawid. This macro counts all checkboxes and adds how many are completed to the title of the page. It also counts how many exclamation, question, star, and pin tags there are. This version counts all checkbox style tags (including CheckBox priority 1 - n, meeting checkboxes, starred checkboxes etc). Furthermore, it counts all checkbox tags applied to the same paragraph rather than just 1, so if two checkbox tags are applied to the same paragraph, it will count both of them.

Text To Web Search Link

(1)411

Turns selected text into hyperlink. User can find words or phrases on the internet without copy pasting the text to browser. Choises of search engines are Bing and Google. Options are "Web", "Images", and "Videos". Helpful for online research, especially when you have many phrases to look up.

All Section Font Calibri

(0)410

All fonts change to Calibri, Titles to Font Size 20

Fix Printout RedX Issue

(0)407

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.

Proofing Language Text -> German(DE)

(0)402

Sets the proofing language on selected text to German(DE)

Sample - Create a new page

(0)395

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

All Section Font Calibri Light

(0)392

All fonts change to Calibri Light, Titles to Font Size 20

Übersichtliche Gestaltung für Checklisten

(1)388

bearbeitet erledigte aufgaben auf den Ebenen 1-4

Convert Zotero scannable cite to a Hyperlink

(1)377

Convert each Quick Copy of Zotero Scanable Cite { | Author, Year | | |zotero://select/items/#_########} on the current page to a hyperlink linked to Zotero. Each cite must in an individual paragraph.

Align Top

(1)370

Aligns Top all selected containers to the topmost selected one

Yellow Text Background

(0)364

Highlights a text to yellow.

Select All Containers

(0)356

Selects All Containers

Table Numbering with Prefix

(0)354

Set a Prefix with numbers 1 to n on selected cells

List hyperlinks from search in new page (choose scope)

(0)350

List hyperlinks from search in new page

Search & Highlight Language

(0)348

Highlight text with a specified proofing language

Sample - Insert Tags

(0)346

Inserts all possible tags on a new page

A4-hoch Skala für Handnotizen

(0)335

Fügt eine A4-hoch breite Skala für Handnotizen ein

Insert Page At Top With YYYY-MM-DD + Title

(1)334

The title is in form of yyyy-mm-dd plus text as entered in a dialogue-box. Result will be e.g. "2016-10-16 Meeting with XYZ". This helps to always keep the newest pages on top and also allows sorting pages 'alphabetically' by date. Helpful if many pages (e.g. meeting minutes of a project or customer are collected in one section).

Clean Strikethrogh

(0)332

Remove strikethrough texts in CurrentPage

Light Ruled Lines for White Page

(0)332

Sets color to a lighter grey for a white background

Insert Page at the Bottom with Short Date and time as Title

(0)328

Inserts a new page at the bottom of the current page stack and sets a short date and time as a page name

Insert FILES

(0)322

Inserts a text string for clickable hyperlink to a file in filesystem

Proofing Language Page -> English (UK)

(0)320

Sets the proofing language on selected page to English (UK)

Enspace Hyperlinks

(0)310

Replaces encoded spaces (%20) in hyperlink display text with actual spaces

List hyperlinks from search in new page

(0)309

List hyperlinks from search in new page

Proofing Language -> French (CA)

(2)309

Sets the proofing language on selected text to French (CA)

Add icon to all emails

(0)306

This macro will change the title of each page in the current section to add an email emoji to the beginning (unless it already has one). This has been made specifically for emails sent to OneNote from Outlook. Great from seeing all emails in a section at a glance.

Search links & add text to label

(0)306

Prompts for: scope, text to search in link target, text to add to the label of the links found

Align Bottom

(2)299

Aligns Bottom all selected containers to the bottom most selected one

TXT2TAB

(2)295

Converts selected text into table with 2 columns : Odd-numbered paragraphs in the first column, even-numbered paragraphs in the second column

Font -> Verdana

(0)294

Changes the paragraph fonts on the current page to Verdana (helps with readability). Only the font name changes. (Size, bold facing, italics, highlighting and other font options stay the same.)

Proportional Function

(0)293

Useful for math; for each table cell, it creates a grid of proportions for a specific number and division number of your choosing. WARNING: Create a new scrap page with a table for this to work! (Also, it can only go down/up to a certain integer value, Onetastic limitation.)

Insert One Cell Table

(0)286

Insert a single celled table in an outline.

New Meeting

(1)285

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

Add icon to page title

(0)284

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.

Insert New Page At Top With YYYY-MM-DD + Title

(0)280

The title is in form of yyyy-mm-dd plus text as entered in a dialogue-box. Result will be e.g. "2016-10-16 Meeting with XYZ". This helps to always keep the newest pages on top and also allows sorting pages 'alphabetically' by date. Helpful if many pages (e.g. meeting minutes of a project or customer are collected in one section).

Custom Rule Lines

(1)279

Set spacing and color of grid lines to any value.

Set All First Columns Width to 30 Value

(0)279

It will set first columns to 'locked' set it to width 30 (certain widths below a threshold don't have any effect)

Align Right

(2)277

Aligns right all selected containers to the topmost selected one

GrayBlack Theme

(0)272

Changes the background color of all the pages in a section to GRAY and converts existing text to BLACK.

Insert YYYY-MM-DD

(0)270

Insert YYYY-MM-DD. Original macro by alarsen: https://getonetastic.com/macroland&id=97AF320199992D0BAA87AD68887C8885

Bee Society - MoSCoW

(0)270

Prioritizing using MoSCoW Technique

Create new page with an ID for a Zettel

(0)265

Creates a new Zettelkasten-Page in the current section with title beginning with yyyymmdd

HTML Apostrophe

(0)263

Replace the HTML apostrophe character (&apos) with an apostrophe (').

Recent Edits with Author Info

(0)262

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

Dim "In Attendace" tags

(0)256

Dims "In Attendance" tags in current page so that they don't show up in tag search results

Duplicate Paragraph

(0)255

Creates a new paragraph with the same text as the current paragraph

Copy Current Page to Other Notebooks

(0)254

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

全页字体设为微软雅黑

(1)251

点击这个脚本,即可将当前页的文本全部设置为微软雅黑。(PS:大家如果遇到什么问题,或有什么其他需求可以给我留言(请留下联系方式,以便通知您),或发邮件到 wenmin92@gmail.com)

Toggle Tags w/ strikethrough & date completed

(0)250

Checked tags are disabled, strike-thoughed, & stamped w/ date completed (Only adds complete date to tags not currently disabled). Unchecked tags are enabled & remove strike-through.

Insert Date - ISO 8601 Basic Format

(0)250

Insert YYYYMMDD

Shrink Pages

(0)250

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.

Set Page Level to Three for All Pages in Section

(0)247

Modifies every page level property in current section and sets it to 3

All Section Font Calibri Black Size 11

(1)246

All fonts change to Calibri black size 11 with no highlight color, Titles to Font Size 20

Reset Container Size

(0)241

Resets the container size back to automatic after forever losing the auto-width property due to manually resizing the note container.

Selected text --> Consolas

(0)239

Changes selected text font to Consolas size 10

Create pages from list of titles

(0)231

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

Disable all tags (5)

(0)230

Disable all tags on current page

Normal Text

(1)227

Changes the text style back to normal after code mode (Calibri 11 pt with no background). Works even when no text is selected.

Insert Date - ISO 8601 Extended Format

(0)221

Insert YYYY-MM-DD

转换中文

(0)220

将选定内容的校验语言设为中文,以屏蔽单词拼写问题 (Set the proofing language on selected text to Chinese)

Exponentiate Cells

(1)217

Useful for math; for each table cell, it creates a grid of powers for a specific number of your choosing. WARNING: Create a new scrap page with a table for this to work! (Also, it can only go up/down to a certain integer value, limitation of Onetastic.)

Go to the begining of the page

(0)217

Moves the cursor to the beginning of the page.

Replace Line Breaks with Paragraph Breaks

(0)217

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

Select all printout images beneath selected printout page.

(0)214

This macro will select every picture with a subsequent printout page number so that they can be deleted, probably. Useful for inserted lecture slides that come in sets which encompass multiple lectures. I intend to make a more general version of this which selects images in a page based on y position instead of printout page number.

Insert YYYY/MM/DD

(0)211

Insert YYYY/MM/DD

Insert Date - ISO 8601 Basic Format at Beginning of Page

(0)210

Insert "YYYYMMDD - " at title location

[Activity #] tag & type

(0)204

Inserts bold [Activity #] tag and then prompts user to enter the title of the activity and type of activity in Adler University's course build OneNote books

Rename Links to Single Name

(0)198

Rename Links - useful for batch renaming links to a single name - good for tables when link acts as a button to launch a media file or site

Font -> 맑은 고딕

(0)191

Changes text font on current page to Calibri to match OneNote 2013's style (useful for pasted text)

Proofing Language -> Portuguese (Standard)

(0)188

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

Sort by Tag

(0)186

Sort selected paragraphs by their tag name

Toggle Complete & Strikethrough

(0)184

Every checked tag becomes disabled w/ strike-through, every unchecked tag becomes enabled w/o strike-through.

Add URL to label of links if missing (any scope)

(0)175

Take each link and add its URL to the displayed text

Find Table Rows with Search Term

(0)174

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

Toggle To Do & Strikethrough for Selection

(0)173

Toggles the todo tag and strikethrough for the selected paragraphs

Spanish Proofing

(0)172

Switch proofing and change style to show Spanish text

First-line indent

(0)168

Set a first-line indent of each paragraph. However, it ignores the following cases.

  • Paragraph in the table
  • bulleted paragraph
  • numbered paragraph
  • blank paragraph
  • paragraph other than default style is set
  • "center" or "right" alignment is set.
  • If you want to change the default value of each setting, please edit the macro.

    Move page with a given string in the title to end of section

    (1)164

    Move page with a given string (case-insensitive) in the title to end of section

    我的评论

    (0)161

    Insert a comment by the current author at the end of the current paragraph

    Proofing Language Page-> Dutch (NL)

    (0)157

    Sets the proofing language on selected page to Dutch (NL)

    Insert page with selected text as title

    (0)154

    Inserts a new page at the bottom of the section and makes the selected text the title. It also creates a link back to the original page.

    Rename Selected Links to Single Name

    (0)154

    Rename Selected Links - useful for batch renaming links to a single name - good for tables when link acts as a button to launch a media file or site (selected links only)

    [PDF] tag & text

    (0)151

    Inserts bold [PDF] tag and then prompts user to enter authors, year and short title of the PDF document in Adler University's course build OneNote books

    Convert Paragraph Font to Segoe UI

    (0)150

    Standard text on the page will now be Segoe UI 10 and headings will be Segoe UI 14

    Proofing Language -> French

    (0)149

    Sets the proofing language on selected text to French

    Obscure Toggle

    (0)147

    Convert Selected Text into other text based on key requested from user. Same process will convert back to original if same key is supplied. (This mimics the way Evernote encryptation works, but the algorithm here is quite weak. Note that spaces, quotation marks and control characters such as carriage returns are simply passed through.)

    Proofing Language Text -> Dutch (NL)

    (0)147

    Sets the proofing language on selected text to Dutch (NL)

    Créer page avec Tag

    (0)146

    Crée une page avec le tag choisi

    Proofing Language -> Spanish (es-ES)

    (1)141

    Sets the proofing language on selected text to Spanish (es-ES)

    全页字体等线

    (0)132

    Changes text font on current page to Microsoft Yahei (for Chinese typing, refers to macro'Font -> Calibri')

    Insert Dated Page with Section

    (1)132

    Inserts a new page with title as date and section name. Update to 'Insert Dated Page at the Top' by Cyrus/Omer Atay to append the section name at the end of the title as well. Also add's the page to the bottom of the section rather than at the top.

    Sample Insert Text

    (0)131

    Inserts text at the current position

    [Page] tag & text

    (0)130

    Inserts bold [Page] tag and then prompts user to enter the author, year, page title and URL for a web page or web site in Adler University's course build OneNote books

    Replace [KW] with current calendar week

    (0)130

    Replaces placeholders with pattern [KW] or [KW]+d; (where d is a digit) with the corresponding calendar week (adding the digit behind +)

    Set Left = 0

    (0)129

    Sets Container(s) Left = 0

    Sample - Custom Sort Notebooks

    (2)128

    Sort notebooks by after the first 6 characters of name

    Add Author to Title

    (1)126

    Modifies the page title to append the author's name

    Append Date to Title (dd.mm.yy)

    (0)123

    Modifies the page title to append the date in DD.MM.YY format

    Change Tag Text

    (0)117

    Change the text that appears when you hover over a tag. The new text have more than one line. Select anyplace in paragraph that contains the tag whose text your want to modify.

    Offline Reading tag & text

    (0)115

    Inserts bold Offline Reading tag and then prompts user to enter authors, year, short title and chapters of textbook in Adler University's course build OneNote books

    Highlight Hashtags

    (0)112

    Highlights hashtags (#word)

    Color PowerShell Comments

    (0)108

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

    Crear título fecha

    (0)107

    "AAAA-MM-DD Título_opcional" con fuente por defecto

    Proofing Language Page -> Polish (PL)

    (1)101

    Sets the proofing language on selected page to Polish (PL)

    Collect Clipped URLs

    (0)100

    Collect clipped URLs from current section or notebook

    Untag/Select All Completed Tasks

    (0)97

    Untag and select all completed checkbox tasks for easy deletion within the page being edited.

    Sample Create Section Hierarchy

    (0)97

    Creates a sample section group/section hierarchy

    Proofing Language -> Dutch (NL)

    (0)96

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

    Color VB Comments

    (0)86

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

    Select Highlighted

    (0)86

    Selects all highlighted text on the page

    Add Footer to All Pages

    (0)84

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

    Create Take a Test App link

    (0)79

    Converts selected URL to URL used by new Take a Test App in Windows 10 Education edition.

    [Interview] tag & text

    (0)78

    Inserts bold [Interview] tag and then prompts user to enter the title of the interview, Kaltura vido's entry ID, and title of video as it appears in the Kaltura video in Adler University's course build OneNote books

    Set Proofing Language to en-gb or pl-pl

    (0)78

    Toogle proofing language on selected text between en-gb and pl-pl

    Proofing Language Text -> Polish (PL)

    (0)77

    Sets the proofing language on selected text to Polish (PL)

    Task Count++

    (0)74

    Modified version of Task Count by Dawid. This macro counts all checkboxes and adds how many are completed to the title of the page. This version counts all checkbox style tags (including CheckBox priority 1 - n). Furthermore, it counts all tags applied to the same paragraph rather than just 1, so if two checkbox tags are applied to the same paragraph, it will count both of them.

    Color PowerShell Comments + NoSpell

    (0)73

    Changes color of text starting with a hash comment (#) on selected lines to green and remove spell checks

    Vote Count

    (0)72

    This macro will count the todo list tag for voting purposes on a collaboration workspace such as on OneNote Classroom Creator. The result of the vote is displayed on the header. in order to use the Vote count you should create a list of voters. Giving them a to do list. Each votore check the to do list. it means voted.

    Set Page to Staedtler Engineer

    (0)72

    Set the Page to emulate Staedtler engineering computation pad ala TOPS TOP35502

    Insert page Title at Cursor

    (0)71

    Inserts current page title + " - " at cursor

    Proofing Language Page -> German (CH)

    (0)70

    Sets the proofing languae on selected page to German (CH)

    SetstatusRecycle

    (0)69

    Sets background of currently selected to orange

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

    (0)69

    Select pasted text name (must be bold) and link from YouTube video name and link, then reformat in only one line reduced format

    Capitalize Page Titles

    (0)63

    Capitalize titles of pages under selected scope

    Proofing Language -> Czech (CZ)

    (0)62

    Sets the proofing language on selected text to Czech (CZ)

    [Panel Discussion] tag & text

    (0)60

    Inserts bold [Panel Discussion] tag and then prompts user to enter the title of the panel discussion, Kaltura vido's entry ID, and title of video as it appears in the Kaltura video in Adler University's course build OneNote books

    Proofing Language -> Slovenian (SLO)

    (0)57

    Sets the proofing language on selected text to Slovenian (SLO)

    Add Collmex Link

    (0)50

    Creates a link to collmex customer from selected text. Collmex is a german ERP cloud solution at www.collmex.de. How to use: Adjust your own collmex number. Then start using: Every of your customer gets a unique number. Just type this number, select the number and this macro will insert a link to this specific customer.

    Sample - Move Last Row To Top

    (1)50

    Sample macro showing how to rearrange rows in a table

    Insert REVERSE

    (0)46

    Inserts text string REVERSE with red background and white font color

    创建任务卡

    (0)43

    在当前页面创建任务卡

    Sort Paragraphs by Highlight Color

    (0)42

    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

    Format Numbers

    (0)41

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

    Proofing Language Text -> German(AT)

    (0)40

    Sets the proofing language on selected text to German(AT)

    Proofing Language Page -> Spanish (ES)

    (0)32

    Sets the proofing language on selected page to Spanish (ES)

    Select Between First two Heading 1

    (0)23

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

    Proofing Language -> Danish

    (0)21

    Sets the proofing language on selected text to Danish

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

    (0)20

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

    Add current paragraph link to currently selected text

    (0)18

    Transform into an hyperlink to their own paragraph all selected texts in the current page

    Proofing Language -> Swedish

    (0)13

    Sets the proofing language on selected text to Swedish

    Set Page Level to 1 for All Pages in Section

    (0)13

    Modifies every page level property in current section and sets it to 1

    Generate Random String

    (0)11

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

    Proofing Language Page -> Bulgarian (BG)

    (0)9

    Sets the proofing language on selected page to Bulgarian(BG)

    Set Page Level to Two for All Pages in Section

    (0)9

    Modifies every page level property in current section and sets it to 2

    字体修正

    (0)4

    不会修改页面中的”Consolas“字体。修改自”中英样式“,未免丢失上传。

    Sentence Case

    (0)3

    Capitalize the first letter in each sentence in the selected text

    Search & Replace in Titles

    (0)3

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