macroland Macroland

Macroland currently has 336 macros by 175 authors

Most Popular

Sort Pages

by Omer Atay, timcurran

(4)30921 Downloads

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

Last Updated: June 20, 2016

Sort Pages

Sort direction

Insert Monthly Calendar

(11)30589

Inserts a calendar of the selected month and year

TOC in Current Notebook

(9)29482

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

Insert Horizontal Line

(9)19617

Inserts a horizontal line

TOC in Current Section

(7)19598

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

Insert Monthly Calendar - Alternative

(5)18701

Inserts a calendar of the selected month and year; Large format option enables setting a width and height.

TOC in Current Page

(10)17519

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

(1)13705

Sort each section in current section group by name

Search & Replace

(9)13291

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

Sort Pages By Date

(2)12211

Sorts pages in current section by created or last modified date

Sort Notebooks

(2)9213

Sort notebooks by name

List Notebooks

(4)8818

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

Where am I

(3)8767

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

Blackboard page

(6)8585

Make the background color of the page black.

Insert Double Horizontal Line

(7)8356

Inserts a double horizontal line

Resize Images

(4)7839

Resizes each image and printout in the current page by given percentage. This extension allows to choose either all images or the selected image only on the current page to be resized.

Sort Pages By Date +

(1)7629

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.

Sort Table

(2)7515

Sorts selected table by selected column

Recent Edits

(4)6571

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

Text to Table

(2)6478

Converts selected text into table

UPPER CASE

(4)6425

Convert selected text to upper case

Word Count

(8)6010

Displays the number of words and characters on the page

Tag Summary for Specific Tag

(2)5804

Creates a tag summary page for a specific tag

Capitalize Each Word

(3)5572

Capitalize each word in the selected text

Insert Date Created or Completed

(2)5519

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

Function

(0)5091

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

lower case

(3)4896

Convert selected text to lower case

Sort Selected Paragraphs

(2)4779

Sorts selected paragraphs or list items

Attachment List in Current Notebook

(1)4770

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

Search & Highlight

(2)4583

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

Number of Pages

(2)4388

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

Background Color List

(1)4234

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.

Sort Selected Todos

(2)3963

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

Set Section Color

(2)3947

Sets Section Color to selected color

TOC in Current Notebook

(1)3900

Creates a table of contents of the current notebook where you need

Insert Long Date

(1)3750

Insert long-format date

Set All Pictures as Background

(1)3635

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

tOGGLE cASE

(4)3574

Toggle casing of selected text

Where am I +

(3)3545

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

Search Multi-Keywords

(5)3515

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.

Word Count - Selected

(4)3506

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

Capitalize Titles

(3)3398

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

No Spell Check

(3)3343

Removes spell check (red squiggles) from selected text

Tag Complete & Strikethrough

(2)3332

Completes the Todo tag and strikes through the selected paragraph

Set Column Widths

(3)3212

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

Sublime Theme

(1)3151

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.

Tag Summary with Page Names

(0)3095

Creates a tag summary page with page names and links for each tag

Increase Font Size

(1)3091

Increases font size of all text on the page by 1

Indent Paragraphs

(1)3028

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.

Set Proofing Language

(2)3013

Prompt user to set proofing language on selected text.

Perfect Printouts

(0)2974

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.

Show uncompleted to dos

(0)2901

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

Insert Subpage With Selected Text As Title

(1)2872

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.

Set Page Color

(1)2819

Sets Page color to selected custom color

Outlook Email Date Stamp

(2)2720

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.

Auto-fill

(1)2699

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

Column Widths+

(2)2668

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

Clean Authors (Select Scope)

(1)2642

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

Expand/Collapse Outlines

(1)2611

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

Remove Paragraph Breaks

(3)2580

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

Decrease Font Size

(1)2544

Decreases font size of all text on the page by 1

Insert Horizontal Line between Paragraphs

(0)2435

Inserts a horizontal line between each of the selected paragraphs

Color Sections by Section

(2)2411

Color all Sections in current SectionGroup by the current Section color

Set Page Font

(1)2379

Sets the whole page to 1 specific font.

Title -> Calibri Light 20

(1)2374

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

Sort Tags

(1)2263

Sort items by whether they are complete or not.

Collapse Parent

(2)2252

Collapse parent outline element

Select Images

(1)2206

Selects all images on the page

Clean Timestamps

(1)2203

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

Insert Page at the Top

(0)2126

Inserts a new page at the top of the current section

Collapse Pages

(2)2115

Collapse all Pages in the current Section

Apple

(1)2009

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

Teal

(1)1997

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

Fit printout images to Letter template - for entire section

(0)1950

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

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

Set Notebook Color

(1)1865

Changes notebook color to hexadecimal value.

Programmer (Sensitive Eyes)

(0)1828

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.

Insert Time Stamp

(0)1821

Insert YYYYMMDD-HHMMSS

Select Done Tasks

(0)1809

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

Tag Completion Date

(1)1787

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

Clean Hyperlinks

(3)1722

Removes all friendly hyperlinks in the current page

Extract segment

(1)1706

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

Search & Select

(1)1693

Select search terms in the current page

Resize and space

(3)1668

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

Insert legal symbol

(2)1641

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

Select Text With Similar Formatting

(1)1631

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

Font -> Calibri

(1)1603

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

Insert Subpages With Selected Paragraphs As Title

(2)1590

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

Weekly Planner

(0)1568

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

Clear Cells

(1)1527

Delete text from selected cells

Insert DD Month YYYY

(1)1496

Insert DD Month YYYY

Programmer (Wombat)

(0)1413

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.

Customize the Title

(0)1389

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

Cleans author information from the current page

Dim Tags

(1)1353

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

Enables or disables rule linese in given scope

Insert Time Last Modified

(2)1319

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

Collapse Pages in Notebook

(0)1315

Collapse all pages in the current Notebook

Tag Complete & Add Date

(0)1306

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

Columns Width of Selected Table

(0)1304

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

Makes background Yellow, brighter than default Lemon color

Insert Subpage

(0)1278

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

Move Page to Top of Section

(1)1255

Moves the current page to the top of the section

Add link

(1)1210

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

Uncheck all todo boxes on the current page

Sort Table (optional header)

(0)1171

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

Insert Time Stamp ISO

(0)1170

Insert YYYY-MM-DD HH:MM:SS

Purple

(1)1168

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

Background Color Selector

(0)1167

This macro gives you the option to set the current page background color using most available HTML color names or by entering the appropriate hexadecimal color value.

Undim Tags

(1)1161

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

Grey Rulelines for Black Pages (Page)

(0)1158

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)

Collapse all

(0)1108

Collapse all subpages

Collapse Pages in SectionGroup

(0)1073

Collapse all pages in the current SectionGroup

Undo No spell check

(0)1067

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.

Expand Pages

(0)1021

To expand pages

BG: Blue

(1)1016

Highlights a text blue.

Reference Pages in this Section

(1)1008

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

Prepend Creation to Title

(2)1000

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

Add @Context

(0)997

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.

Align Left

(2)992

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.

Create a title for the page

(0)974

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

Outlook FROM SubPager

(1)969

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

Go to end of the page

(1)959

Moves the cursor to the end of the page

Table to Matrix

(1)952

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

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

Proofing Language Text -> English (UK)

(2)935

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

Un/Complete Tasks

(1)922

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.

Sort Pages

(1)916

Sort pages within a section and subpages within a parent page alphabetically

Tag Summary for Specific Tag with Page Name

(0)916

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

Clean Authors From Section

(1)912

Cleans author information from all pages in the current section

Collapse Pages in Notebooks

(0)908

Collapse all pages in all Notebooks

Dark Ruled Lines for Black Pages

(1)903

Sets color to a dark grey for a black background

Set Page Time

(1)900

Set the page time to desired time

Insert Dated Page at the Top

(0)896

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

Color (Select Scope)

(1)893

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

Sort All Paragraphs

(0)883

Sort all paragraphs on the page and optionally empty duplications

Page Template Name

(1)879

Displays the original template used to create the current page

Toggle Complete/Strikethrough and Sort

(1)877

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.

Prio

(0)861

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.

Number Cells

(0)858

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

Tag Incomplete

(0)841

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

Resize Images by Pixels

(2)820

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

Proofing Language Page -> English (US)

(1)811

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

Insert Comment

(0)811

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

Search & Spell Check Off

(2)811

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.

Clean Hyperlinks and HTML spaces

(0)746

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!

Shift all images up and left

(0)735

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

Platinum

(0)701

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

Search & Bold

(0)700

Bold search terms in the current page

All Section Font Calibri Light

(0)693

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

HTML Space

(0)686

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

Insert Short Month Date

(0)684

Insert short month format date

FG: White

(0)681

Colors a text in white.

Collapse All Parents

(0)681

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

Set images not as background

(2)671

Sets all images as not background.

Title -> Calibri Light 20 (Current page only)

(0)668

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

Completed tags - grey out, checked date

(0)668

Grey out completed tags and write date when it was completed

Extract highlighted Text

(1)661

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

Insert Date

(0)649

Insert long-format date

中英样式

(1)638

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

Tag Started and Completed

(1)627

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.

Add URL to label of links

(0)610

Take each link and add its URL to the displayed text

New Website

(0)607

Create a predifine structure for current Webpage

Remove All Indents From All Paragraphs

(0)588

For every paragraph, it will sent the indent to nothing

设置默认格式

(2)572

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

Set All Pages In Section Color

(0)555

Sets All Pages in selected Section color

Dim Selected Tags

(1)551

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

Bring selected stacked image to front

(0)549

Simple macro using z property - useful for stacked offset images

Insert SubPage with Data as Title

(0)548

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

Matrix to Table

(0)542

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

Print/SaveAs SimpleHelper - Grid 0.5" on LetterPaper

(0)534

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

Zotero Link in form of Author, Year

(1)533

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.

Move empty pages to end of section

(0)530

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

Replace Page Title with Text Selection

(0)524

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

全页字体微软雅黑

(0)488

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

Align and Space

(0)487

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

Sort paragraphs and Empty Duplications

(0)486

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

Mark All Pages as Read

(0)481

This will mark each page in the current Section as Read

Vehicle Auction_Spaced

(0)479

A new vehicle auction

Sort each paragraph on the page Ascending

(0)473

Exclude empty paragraph and title and no selection needed.

Toggle Red/Black

(0)473

Toggles selected text between red and black font colour.

Reset Stacked Image Order

(0)466

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

Number Selected Cells

(0)463

Set numbers from 1 to n to the sellected Cells

Insert Page at the Top with Short Date as Title

(0)454

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

White-BG

(0)435

Make the background color of the page white

Font -> Courier New 9

(0)430

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

Set label of links to URL

(0)429

Take each link and set its displayed text to the URL

Proofing Language Text -> English (US)

(0)427

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

Insert Short Date Stamp

(0)420

Insert YYMMDD -

Clone Hyperlinks

(0)416

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)

Clean External Hyperlinks

(0)415

Removes all external hyperlinks, leaving internal and files intact

Sort Completed

(0)412

Sorts all todo lists on the page by completed status.

Insert Day and Date

(0)407

Insert DD Day

Number Cells in a Specific Column

(0)401

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

Toggle Complete/Strikethrough

(0)400

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

Reformat Quick Paste text and URL into a hyperlink

(0)387

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

Grey out completed

(0)379

Grey out completed tags and write date when it was completed

Next Unfinished To-Do Item

(0)366

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.

Scale

(0)361

Inserts fixed-font 80 point scale

Number First Cells

(0)360

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

Selected text --> Calibri 12 Black

(0)348

Changes selected text font to Calibri size 12 black

Copy text to first Page

(0)346

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!

All Section Font Calibri Light

(0)338

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

Add link and rename URL text to display

(0)335

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

Convert Zotero scannable cite to a Hyperlink

(1)320

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.

Create Page With Completed Tag Summary

(0)318

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.

Grey Out & Strike Through Completed

(0)311

Grey out and strike through completed tags

Input Font (Select Scope)

(0)305

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.

Search & Highlight Language

(0)302

Highlight text with a specified proofing language

Clean Strikethrogh

(0)300

Remove strikethrough texts in CurrentPage

changepagecolors

(0)292

Prompts user for a page color and then changes the current page to the color specified in the prompt

Fix Printout RedX Issue

(0)291

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.

Übersichtliche Gestaltung für Checklisten

(1)288

bearbeitet erledigte aufgaben auf den Ebenen 1-4

Proofing Language -> French (CA)

(2)282

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

Add some BBcode tags

(0)271

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.

Create new page with an ID for a Zettel

(0)271

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

Sample Notebook/Section/Page Picker

(0)268

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

Enspace Hyperlinks

(0)255

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

Transpose Table

(0)253

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.

Input Font (Select Scope)

(1)246

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.

Proofing Language Text -> German(DE)

(0)245

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

Proportional Function

(0)244

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

Task count

(0)244

Adds or updates done task count in current page title. If page contains Questions (question mark) or Important (star) tags - ? and/or * will be included in title. All informations form macro will be included in square brackets before current page title.

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

(0)243

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

Search links & add text to label

(0)241

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

Text To Web Search Link

(1)239

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.

Table Numbering with Prefix

(0)237

Set a Prefix with numbers 1 to n on selected cells

Black Theme

(0)232

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

HTML Apostrophe

(0)231

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

Set All First Columns Width to 30 Value

(0)212

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

Bee Society - MoSCoW

(0)212

Prioritizing using MoSCoW Technique

All Section Font Calibri

(0)205

All fonts change to Calibri, Titles to Font Size 20

List hyperlinks from search in new page (choose scope)

(0)200

List hyperlinks from search in new page

Proofing Language -> English (UK)

(0)199

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

Duplicate Paragraph

(0)199

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

Sample - Create tables

(0)196

Creates sample tables in the current page

List hyperlinks from search in new page

(0)193

List hyperlinks from search in new page

Proofing Language Page -> English (UK)

(0)187

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

Set Page Level to Three for All Pages in Section

(0)186

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

Custom Theme

(0)186

apply your theme. please edit macro.

Yellow Text Background

(0)185

Highlights a text to yellow.

Exponentiate Cells

(0)181

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

Disable all tags (5)

(0)179

Disable all tags on current page

TXT2TAB

(1)176

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

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

转换中文

(0)171

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

Proofing Language -> Portuguese (Standard)

(0)155

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

Sample - Create a new page

(0)155

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

Spanish Proofing

(0)152

Switch proofing and change style to show Spanish text

Dim "In Attendace" tags

(0)150

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

Selected text --> Consolas

(0)150

Changes selected text font to Consolas size 10

Font -> 맑은 고딕

(0)146

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

Rename Links to Single Name

(0)145

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

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

(0)143

Take each link and add its URL to the displayed text

All Page Font Calibri Size 11

(1)136

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

Toggle Tags w/ strikethrough & date completed

(0)128

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.

[Activity #] tag & type

(0)128

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

Search & Tag

(1)125

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

Proofing Language Page-> Dutch (NL)

(0)124

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

Set rule lines on/off in scope

(0)123

Enables or disables rule linese in given scope

Rename Selected Links to Single Name

(0)121

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

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

Proofing Language Text -> Dutch (NL)

(0)118

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

Proofing Language -> Spanish (es-ES)

(1)112

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

Créer page avec Tag

(0)111

Crée une page avec le tag choisi

Sample - Insert Tags

(0)107

Inserts all possible tags on a new page

Toggle To Do & Strikethrough for Selection

(0)106

Toggles the todo tag and strikethrough for the selected paragraphs

Select all printout images beneath selected printout page.

(0)100

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.

Toggle Complete & Strikethrough

(0)98

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

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

(0)93

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

Proofing Language Page -> Polish (PL)

(1)87

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

Proofing Language -> French

(0)82

Sets the proofing language on selected text to French

Table to Text

(1)80

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

Align Left

(0)79

Aligns Left all selected containers to the topmost selected one

Copy Current Page to Other Notebooks

(0)76

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

Obscure Toggle

(0)76

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

[Page] tag & text

(0)76

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

Crear título fecha

(0)76

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

我的评论

(0)74

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

Offline Reading tag & text

(0)73

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

Create Task Cards

(1)71

Create tasks cards on the page

Add Comment

(0)69

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.

Veritical Spacing

(0)67

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.

Set Proofing Language to en-gb or pl-pl

(0)66

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

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

(0)65

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

Proofing Language Text -> Polish (PL)

(0)65

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

A4-hoch Skala für Handnotizen

(0)64

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

Insert Date - ISO 8601 Extended Format

(0)62

Insert YYYY-MM-DD

All Section Font Calibri Black Size 11

(1)60

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

Team Activity Tracker

(0)58

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!

Annotate

(0)57

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.

Reset Container Size

(0)57

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

Proofing Language -> Dutch (NL)

(0)56

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

Horizontal Spacing

(0)55

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.

Create Take a Test App link

(0)54

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

First-line indent

(0)52

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.

    [Interview] tag & text

    (0)52

    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

    Sort Pages in all Sections in Notebook

    (0)51

    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

    Light Ruled Lines for White Page

    (0)46

    Sets color to a lighter grey for a white background

    Sample - Custom Sort Notebooks

    (1)44

    Sort notebooks by after the first 6 characters of name

    Proofing Language -> Slovenian (SLO)

    (0)43

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

    Align Right

    (1)43

    Aligns right all selected containers to the topmost selected one

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

    (0)43

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

    Select All Containers

    (0)42

    Selects All Containers

    Proofing Language -> Czech (CZ)

    (0)40

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

    [Panel Discussion] tag & text

    (0)40

    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

    SetstatusRecycle

    (0)39

    Sets background of currently selected to orange

    Go to the begining of the page

    (0)38

    Moves the cursor to the beginning of the page.

    Insert FILES

    (0)36

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

    Shrink Pages

    (0)36

    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.

    Align Top

    (0)34

    Aligns Top all selected containers to the topmost selected one

    Insert Date - ISO 8601 Basic Format

    (0)33

    Insert YYYYMMDD

    全页字体等线

    (0)32

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

    White Theme

    (0)32

    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

    Color VB Comments

    (0)31

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

    Align Bottom

    (1)31

    Aligns Bottom all selected containers to the bottom most selected one

    Replace Line Breaks with Paragraph Breaks

    (0)30

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

    Insert Date - ISO 8601 Basic Format at Beginning of Page

    (0)27

    Insert "YYYYMMDD - " at title location

    Proofing Language Text -> German(AT)

    (0)26

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

    Set Page Font to Segoe Pro 11

    (0)26

    Standard text on the page will now be Segoe Pro Black 11 and titles will be 20.

    Insert One Cell Table

    (0)26

    Insert a single celled table in an outline.

    Add Collmex Link

    (0)24

    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.

    Proofing Language Page -> German (CH)

    (0)24

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

    Find Table Rows with Search Term

    (0)23

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

    Vote Count

    (0)23

    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.

    Insert page with selected text as title

    (0)22

    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.

    Create new page with an ID for a Zettel

    (0)21

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

    TOC in Current Subpages

    (0)14

    Creates a table of contents of the current page subpages

    Change Tag Text

    (0)13

    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.

    Proofing Language Page -> Spanish (ES)

    (0)12

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

    Clipped URLs

    (0)12

    Collect

    Insert REVERSE

    (0)6

    Inserts text string REVERSE with red background and white font color

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

    (0)3

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

    Sample - Move Last Row To Top

    (0)3

    Sample macro showing how to rearrange rows in a table

    Insert YYYY/MM/DD

    (0)2

    Insert YYYY/MM/DD

    Proofing Language Page -> Bulgarian (BG)

    (0)0

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