macroland Macroland

Macroland currently has 507 macros by 263 authors

Most Popular

Insert Monthly Calendar

by Omer Atay , that0n3guy 72953 Downloads

Inserts a calendar of the selected month and year

Last Updated: January 23, 2018

Sort Pages

65171

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

TOC in Current Notebook

54722

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

TOC in Current Page

39137

Creates a table of contents from heading in the current page and inserts at the top of the page. Optionally it adds "Back to Top" links to the headings.

Insert Horizontal Line

38999

Inserts a horizontal line

TOC in Current Section

38744

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

Search & Replace

36847

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

Less Popular

Sort Sections

by Omer Atay 29346 Downloads

Sort each section in current section group by name

Last Updated: August 24, 2017

Sort Sections

Sort direction
Scope

Resize Images

28429

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

26904

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

Weekly Planner

22713

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

Sort Notebooks

19362

Sort notebooks by name

Blackboard page

16740

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

Function

15537

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

List Notebooks

14505

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

Sort Pages By Date +

13452

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

13235

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

Insert Double Horizontal Line

13050

Inserts a double horizontal line

Word Count

12220

Displays the number of words and characters on the page

Text to Table

12144

Converts selected text into table

Search & Highlight

12015

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

Sort Table

11651

Sorts selected table by selected column

Tag Summary for Specific Tag

10781

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

Recent Edits

10764

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

UPPER CASE

9787

Convert selected text to upper case

Background Color List

9565

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.

Attachment List

9559

Creates a list of attachment filenames in current section, section group or notebook. Provides page names and links back to the page and the embedded files.

Increase Font Size

8615

Increases font size of all text on the page by 1

Capitalize Each Word

8470

Capitalize each word in the selected text

Auto-fill

8161

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

Number of Pages

8102

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

Set Section Color

7972

Sets Section Color to selected color

Insert Yearly Calendar

7840

Inserts a calendar of the selected year

Select Images

7831

Selects all images on the page

Decrease Font Size

7568

Decreases font size of all text on the page by 1

Insert Date Created or Completed

7480

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

Perfect Printouts

7418

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.

Sort Selected Paragraphs

7345

Sorts selected paragraphs or list items

lower case

7238

Convert selected text to lower case

Monthly Calendar With Task List

7129

修改自 Insert Monthly Calendar.

Sublime Theme

6711

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.

Clean Hyperlinks

6582

Removes all friendly hyperlinks in the current page

Where am I +

6529

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

6299

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.

No Spell Check

6249

Removes spell check (red squiggles) from selected text

Set All Pictures as Background

6191

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

Tag Summary with Page Names

6101

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.

Clean Authors

6025

Cleans author information from the current page

Sort Selected Todos

5962

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

Word Count - Selected

5933

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

Daily planner Page (Today)

5498

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

Capitalize Titles

5286

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

Outlook Email Date Stamp

5282

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.

Insert Long Date

5197

Insert long-format date

Set Column Widths

5178

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

Team Activity Tracker

5171

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!

tOGGLE cASE

5158

Toggle casing of selected text

Tag Complete & Strikethrough

5026

Completes the Todo tag and strikes through the selected paragraph

Show uncompleted to dos

4876

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

Column Widths+

4765

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

Expand/Collapse Outlines

4765

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

Indent Paragraphs

4332

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.

Programmer (Sensitive Eyes)

4332

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 Subpage With Selected Text As Title

4269

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.

Color Sections by Section

4219

Color all Sections in current SectionGroup by the current Section color

Set Page Font

4186

Sets the whole page to 1 specific font.

Clean Authors (Select Scope)

4170

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

Set Proofing Language

4165

Prompt user to set proofing language on selected text.

Resize and space

4165

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

Remove Paragraph and Line Breaks

4134

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

Collapse Pages

4059

Collapse all Pages in the current Section

Insert Horizontal Line between Paragraphs

4032

Inserts a horizontal line between each of the selected paragraphs

Sort Tags

4014

Sort items by whether they are complete or not.

Apple

3939

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

Set Notebook Color

3740

Changes notebook color to hexadecimal value.

Search & Replace in Hyperlinks

3680

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

Create Task Cards

3629

Create tasks cards on the page

Insert Page at the Top

3623

Inserts a new page at the top of the current section

Insert Time Stamp

3617

Insert YYYYMMDD-HHMMSS

Fit printout images to Letter template - for entire section

3611

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.

Content Map in Current Page

3541

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.

To-Do List with Page Names

3464

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

Title -> Calibri Light 20

3455

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

Content Map in Current Section

3434

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.

Diary Pages

3420

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

Show Month

3370

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

Programmer (Wombat)

3368

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.

Search & Select

3305

Select search terms in the current page

Sort Pages Ascending

3294

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

Clean Timestamps

3216

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

Collapse Parent

3152

Collapse parent outline element

TOC in All Notebooks

3151

Creates a new page with table of contents of all notebooks

Black Theme

3149

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

Insert DD Month YYYY

3137

Insert DD Month YYYY

Code mode

2962

Changes the text style to code (Consolas 10 pt, with a very light background, reminiscent of Evernote Code Blocks). Works even when no text is selected.

Sort Table (optional header)

2924

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

Teal

2915

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

Select Done Tasks

2912

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

TOC in Current Subpages

2895

Creates a table of contents of the current page subpages

Tag Completion Date

2838

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

Tag Complete & Add Date

2797

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

Font -> Calibri

2762

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

Add Comment

2757

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.

Insert legal symbol

2750

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

Insert Comment

2581

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

Perfect Printouts II

2559

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.

Color (Select Scope)

2546

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

Select Text With Similar Formatting

2466

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

Extract segment

2439

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

Collapse Pages in Notebook

2433

Collapse all pages in the current Notebook

Insert Time Last Modified

2417

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

Customize the Title

2415

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

Tag Summary for Specific Tag with Page Name

2388

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

Insert Subpage

2384

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

Resize Images by Pixels

2373

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

Insert Subpages With Selected Paragraphs As Title

2303

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

Clear Cells

2301

Delete text from selected cells

Move Page to Top of Section

2263

Moves the current page to the top of the section

Columns Width of Selected Table

2249

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

Daily Manager Log

2193

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

Set Page Date & Time

2174

Set the page date and time to desired time

Lemon

2164

Makes background Yellow, brighter than default Lemon color

Uncheck All Todos

2154

Uncheck all todo boxes on the current page

Add link

2117

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

Set rule lines on/off in scope

2094

Enables or disables rule linese in given scope

Extract highlighted Text

2084

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

Weekly Planner for each day with Done&TODO

2066

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

Dim Tags

2039

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

Collapse Pages in SectionGroup

2029

Collapse all pages in the current SectionGroup

Insert Time Stamp ISO

2025

Insert YYYY-MM-DD HH:MM:SS

Un/Complete Tasks

1977

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.

Undo No spell check

1962

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.

Grey Rulelines for Black Pages (Page)

1956

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)

Insert Dated Page at the Top

1945

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

Prepend Creation to Title

1934

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

Proofing Language Page -> English (US)

1926

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

Sort All Paragraphs

1913

Sort all paragraphs on the page and optionally empty duplications

Expand Pages

1907

To expand pages

Prio

1885

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.

Purple

1878

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

Align and Space

1876

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

BG: Blue

1839

Highlights a text blue.

Custom Grid Lines

1820

Set spacing and color of grid lines to any value.

Platinum

1805

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

Reference Pages in this Section

1801

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

Outlook FROM SubPager

1794

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

Sort Pages in all Sections in Notebook

1790

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

Add @Context

1789

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

1787

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.

Align Left

1778

Aligns Left all selected containers to the topmost selected one

Collapse Pages in Notebooks

1759

Collapse all pages in all Notebooks

全页字体微软雅黑

1723

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

中英样式

1707

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

Create a title for the page

1706

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

Go to end of the page

1705

Moves the cursor to the end of the page

Clean Authors From Section

1673

Cleans author information from all pages in the current section

Undim Tags

1672

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

Toggle Complete/Strikethrough and Sort

1651

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.

Set images not as background

1648

Sets all images as not background.

Number Cells

1633

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

Set All Pages In Section Color

1617

Sets All Pages in selected Section color

Collapse All Parents

1613

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

Dark Ruled Lines for Black Pages

1609

Sets color to a dark grey for a black background

Table to Matrix

1607

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

1600

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

Planner for each day with Done&TODO_withISO_date

1584

Inserts one page for each day in 4 weeks(by default) with Done, Problem and TODO. It can also insert one page per week.

Insert Horizontal Line (A4)

1561

Inserts a horizontal line adjusted for notes (A4)

Proofing Language Text -> English (UK)

1558

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

Table to Text

1556

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

Insert Day and Date

1544

Insert DD Day

Shift all images up and left

1533

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

Search & Tag

1517

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

Veritical Spacing

1515

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.

Custom Theme

1510

apply your theme. please edit macro.

Completed tags - grey out, checked date

1508

Grey out completed tags and write date when it was completed

All Page Font Calibri Size 11

1489

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

Search & Bold

1487

Bold search terms in the current page

Page Template Name

1477

Displays the original template used to create the current page

Annotate

1469

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.

TOC in Current Section Group

1420

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

Sort Completed

1386

Sorts all todo lists on the page by completed status.

Clean Hyperlinks and HTML spaces

1377

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!

Move empty pages to end of section

1377

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

Add icon to page title

1373

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.

Tag Incomplete

1363

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

Sample - Create tables

1328

Creates sample tables in the current page

Search & Spell Check Off

1289

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.

White Theme

1285

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

Insert User Comment

1277

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

Horizontal Spacing

1274

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.

New Meeting

1259

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

Custom Rule Lines

1241

Set spacing and color of grid lines to any value.

GrayBlack Theme

1232

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

Super Color

1232

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

Remove All Indents From All Paragraphs

1231

For every paragraph, it will sent the indent to nothing

Align Top

1216

Aligns Top all selected containers to the topmost selected one

Tag Started and Completed

1208

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.

All Section Font Calibri Light

1208

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

New Website

1202

Create a predifine structure for current Webpage

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

1192

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

Matrix to Table

1182

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

Insert Short Month Date

1157

Insert short month format date

Create Page With Completed Tag Summary

1155

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.

Insert Short Date Stamp

1133

Insert "YYMMDD - "

Number Selected Cells

1126

Set numbers from 1 to n to the sellected Cells

Replace Page Title with Text Selection

1124

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

Title -> Calibri Light 20 (Current page only)

1116

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

HTML Space

1102

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

Insert SubPage with Data as Title

1095

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

Task Count + Tags

1088

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.

Add icon to all emails

1086

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.

设置默认格式

1081

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

Vehicle Auction_Spaced

1081

A new vehicle auction

Sort paragraphs and Empty Duplications

1079

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

Insert Page at the Top with Short Date as Title

1077

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

Number First Cells

1077

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

Recent Edits with Author Info

1075

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

Mark All Pages as Read

1073

This will mark each page in the current Section as Read

Select All Containers

1072

Selects All Containers

Add URL to label of links

1069

Take each link and add its URL to the displayed text

Clean External Hyperlinks

1069

Removes all external hyperlinks, leaving internal and files intact

Insert FILES

1068

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

Insert YYYY-MM-DD

1061

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

FG: White

1058

Colors a text in white.

Grey Out & Strike Through Completed

1051

Grey out and strike through completed tags

Number Cells in a Specific Column

1034

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

Sort each paragraph on the page Ascending

1012

Exclude empty paragraph and title and no selection needed.

Create pages from list of titles

1003

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

Dim Selected Tags

1002

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

Bring selected stacked image to front

996

Simple macro using z property - useful for stacked offset images

Print/SaveAs SimpleHelper - Grid 0.5" on LetterPaper

983

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

Text To Web Search Link

974

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.

Grey out completed

970

Grey out completed tags and write date when it was completed

Insert One Cell Table

965

Insert a single celled table in an outline.

Transpose Table

964

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.

Proofing Language Text -> English (US)

960

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

A4-hoch Skala für Handnotizen

951

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

Toggle Red/Black

945

Toggles selected text between red and black font colour.

Sample Notebook/Section/Page Picker

943

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

Sample - Create a new page

927

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

Zotero Link in form of Author, Year

919

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

916

Sort selected paragraphs by their tag name

Sample - Insert Tags

913

Inserts all possible tags on a new page

Font -> Courier New 9

898

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

Normal Text

895

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

Yellow Text Background

890

Highlights a text to yellow.

Light Ruled Lines for White Page

884

Sets color to a lighter grey for a white background

Selected text --> Calibri 12 Black

883

Changes selected text font to Calibri size 12 black

Align Right

881

Aligns right all selected containers to the topmost selected one

Align Bottom

878

Aligns Bottom all selected containers to the bottom most selected one

Toggle Complete/Strikethrough

877

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

Set Page to Staedtler Engineer

877

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

Copy text to first Page

858

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!

Copy Current Page to Other Notebooks

853

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

Fix Printout RedX Issue

850

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.

Reset Container Size

846

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

Proofing Language Text -> German(DE)

843

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

Next Unfinished To-Do Item

843

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.

全页字体设为微软雅黑

840

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

All Section Font Calibri

837

All fonts change to Calibri, Titles to Font Size 20

Add some BBcode tags

831

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.

Reset Stacked Image Order

824

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

Reformat Quick Paste text and URL into a hyperlink

820

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

Add link and rename URL text to display

816

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

Input Font (Select Scope)

813

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.

List hyperlinks from search in new page (choose scope)

811

List hyperlinks from search in new page

Shrink Pages

803

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.

Scale

802

Inserts fixed-font 80 point scale

Übersichtliche Gestaltung für Checklisten

801

bearbeitet erledigte aufgaben auf den Ebenen 1-4

Sentence Case

795

Capitalize the first letter in each sentence in the selected text

Insert YYYY/MM/DD

778

Insert YYYY/MM/DD

Table Numbering with Prefix

776

Set a Prefix with numbers 1 to n on selected cells

Set label of links to URL

775

Take each link and set its displayed text to the URL

Clone Hyperlinks

773

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)

分别设置中英文字体

762

如果选中文本,则只对选中部分作用,否则对当前页面所有文本作用。 默认中文设为“宋体”,英文设为“Times New Roman”。如果需要自定义,请编辑这个 Macro,分别设置 cnFont 和 enFont 为自己想要的字体即可。如果需要统一设置字体大小也可以更改 fontSize。如果需要将某些字符识别为英文,修改 enChars。关于 OneNote 设置中英文字体,如需了解更多,请移步 http://t.cn/RT8Imz9 ,欢迎一起讨论。(PS:大家如果遇到什么问题,或有什么其他需求可以给我留言(请留下联系方式,以便通知您),或直接发邮件到 wenmin92@gmail.com)

Replace [KW] with current calendar week

755

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

Go to the begining of the page

740

Moves the cursor to the beginning of the page.

Create sections from list of titles

735

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

Sample Insert Text

724

Inserts text at the current position

Insert Page At Bottom With Title

700

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

Letter sized paper with infinite length and ruled horizontal lines

693

Adds a vertical rule line to a letter sized paper with infinite length and ruled horizontal lines. You can change the rule line color afterwards from View > Rule Lines > Rule Line Color if you want.

Select all printout images beneath selected printout page.

693

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.

TXT2TAB

691

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

DateTime Stamp

691

Add properly formatted DateTime stamp

Font -> Verdana

687

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

Dim "In Attendace" tags

682

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

Toggle Tags w/ strikethrough & date completed

677

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.

Proofing Language Page -> English (UK)

677

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

All Section Font Calibri Light

676

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

All Section Font Calibri Black Size 11

676

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

List hyperlinks from search in new page

671

List hyperlinks from search in new page

Insert Date - ISO 8601 Basic Format

667

Insert YYYYMMDD

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

663

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

Toggle To Do & Strikethrough for Selection

660

Toggles the todo tag and strikethrough for the selected paragraphs

Replace Line Breaks with Paragraph Breaks

654

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

Capitalize Page Titles

646

Capitalize titles of pages under selected scope

Create new page with an ID for a Zettel

645

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

Search & Highlight Language

644

Highlight text with a specified proofing language

Clean Strikethrogh

638

Remove strikethrough texts in CurrentPage

Convert Zotero scannable cite to a Hyperlink

636

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.

Append Date to Title (dd.mm.yy)

629

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

Insert Date - ISO 8601 Basic Format at Beginning of Page

619

Insert "YYYYMMDD - " at title location

Insert Date - ISO 8601 Extended Format

613

Insert YYYY-MM-DD

First-line indent

612

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.

    Enspace Hyperlinks

    611

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

    Search links & add text to label

    609

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

    Proportional Function

    606

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

    创建任务卡

    603

    在当前页面创建任务卡

    Insert page with selected text as title

    600

    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.

    Set All First Columns Width to 30 Value

    598

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

    Add Footer to All Pages

    597

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

    Toggle Complete & Strikethrough

    594

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

    Sample Create Section Hierarchy

    590

    Creates a sample section group/section hierarchy

    Highlight Hashtags

    581

    Highlights hashtags (#word)

    Set Left = 0

    571

    Sets Container(s) Left = 0

    [Activity #] tag & type

    570

    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

    Duplicate Paragraph

    564

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

    Find Table Rows with Search Term

    562

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

    Add Date before Title (yy/mm/dd)

    562

    Modifies the page title to add the date in yy/mm/dd format

    我的评论

    553

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

    Bee Society - MoSCoW

    550

    Prioritizing using MoSCoW Technique

    Timer

    550

    Simple timer, click first time to activate the timer (a DialogBox will appear) and then press everytime you want to insert the timer. Useful for taking notes while recording the lecture.

    Task Count++

    542

    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.

    Search & Replace in Titles

    540

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

    Insert Dated Page with Section

    539

    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.

    Selected text --> Consolas

    535

    Changes selected text font to Consolas size 10

    Disable all tags (5)

    524

    Disable all tags on current page

    Proofing Language -> French (CA)

    522

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

    Sublime Theme with // Comments

    515

    Makes the background color of the page dark gray and converts existing text to white. Based on the Sublime text editor. This version also recolors bulleted and numbered lists, and converts lines starting with // to light green.

    Set Page Level to Three for All Pages in Section

    508

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

    HTML Apostrophe

    507

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

    Select Highlighted

    496

    Selects all highlighted text on the page

    全页字体等线

    493

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

    转换中文

    493

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

    Exponentiate Cells

    492

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

    Sample - Custom Sort Notebooks

    490

    Sort notebooks by after the first 6 characters of name

    Color PowerShell Comments

    481

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

    Rename Links to Single Name

    470

    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 Author to Title

    470

    Modifies the page title to append the author's name

    Change Tag Text

    466

    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.

    字体修正by翠翠酱

    455

    正文中文改为微软雅黑12号,英文改为consolas12号,标题为20号,修改自”字体修正“,为避免丢失上传。PS:大家如果遇到什么问题,或有什么其他需求可发邮件到 shadowspacex@163.com)

    TOC of Subpages - Markers

    455

    Creates a table of contents of the current page subpages. The list is put into the selected outline. The difference between this script and "TOC in Current Subpages" is that it creates markes ( ├─{ or └─{ ) to the left of each content item.

    Convert Paragraph Font to Segoe UI

    455

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

    Set Container Width 618

    450

    Sets the container size

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

    446

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

    Color PowerShell Comments + NoSpell

    444

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

    Convert Copied Paths to File Hyperlinks Macro

    441

    Converts selected pasted "Copied Paths" into file hyperlinks. This provides similar functionality now removed from OneNote that allowed files copied from windows explorer to be pasted as hyperlinks. To use; 1-Ctrl Select multiple files within windows explorer, 2-Shift + right click one of the selected files, 3-Choose "Copy as Path" from context menu, 4-Go to OneNote and paste into a page, 5-Select all pasted paragraphs, 6-Select "Convert Copied Paths to File Hyperlinks" from Onetastic's hyperlink menu. See a demo of the macro in action at https://youtu.be/22nMT8wy8Cc. If you find this macro useful please donate to http://www.paypal.me/SimonRear to encourage the development of more useful timesavers.

    Obscure Toggle

    439

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

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

    435

    Take each link and add its URL to the displayed text

    Untag/Select All Completed Tasks

    434

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

    Collect Clipped URLs

    432

    Collect clipped URLs from current section or notebook

    Font -> 맑은 고딕

    431

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

    [Page] tag & text

    425

    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

    Insert Space Between Paragraphs

    423

    Inserts an empty paragraph between each of the selected paragraphs

    Rename Selected Links to Single Name

    411

    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)

    Proofing Language -> French

    405

    Sets the proofing language on selected text to French

    Proofing Language Page-> Dutch (NL)

    402

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

    List Password Protected Sections

    399

    Lists the password protected sections in the current notebook

    Proofing Language -> Portuguese (Standard)

    386

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

    Check All Todos

    385

    Check all todo boxes on the current page

    Proofing Language -> Spanish (es-ES)

    380

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

    Insert Selected Text in a Custom Table

    374

    Styles a selected text (adds a highlight color and an important tag) and builds a custom table for the current section group in a new section [Course Overview], on a new page [Recent Feedback]. New rows are added at the top when further text from the same section group is selected.

    Créer page avec Tag

    373

    Crée une page avec le tag choisi

    Vote Count

    368

    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.

    Proofing Language Text -> Dutch (NL)

    366

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

    TOC in Section - Markers

    362

    Creates or updates a table of contents for current section. It is possible to select if sub-pages should be included or not. The main difference between this script and "TOC in Current Section" is that it inserts markers ( ├─{, └─{ or ┬─{ ) to the left of each content item.

    Insert page Title at Cursor

    358

    Inserts current page title + " - " at cursor

    Spanish Proofing

    351

    Switch proofing and change style to show Spanish text

    Color VB Comments

    344

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

    Offline Reading tag & text

    322

    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

    Calibri2微软雅黑

    321

    把页面中所有Calibri字体的文字修改为微软雅黑字体

    Add current paragraph link to currently selected text

    318

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

    Insert HH:MM:SS Time Stamp

    318

    HH:MM:SS

    Format Numbers

    313

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

    Sort Paragraphs by Highlight Color

    310

    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

    Sort Rows by Tag

    303

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

    Selection as Subpage

    300

    Insert a subpage to the current page using selected text as title. The selected text will be made into a link refering to the new subpage and the new subpage will contain a link back to current page. In case the current page already has one or more subpages the new subpage will bee added in the bottom.

    Tag Action Owner

    290

    Prompts for and tags action owner e.g. [PS] - at beginning of paragraph in bold, red text

    Sample - Move Last Row To Top

    290

    Sample macro showing how to rearrange rows in a table

    Change Text Color

    289

    Change color of all instances of text within the given scope that match the given inputs. Required Inputs: hex code of desired color, Scope, Case sensitivity Optional Inputs: Text to Color, Target Font Name, Target Font Size, Various filters NOTE: Either Text to Color or Target Font Size must be provided, both may also be provided for additional specificity.

    字体修正

    263

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

    Create Take a Test App link

    255

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

    Set Entire Section Font to Segoe UI Family

    248

    This will change all fonts in the section to the Segoe UI (Windows 10 style) family of fonts. Paragraph font Segoe UI 10, Title font Segoe UI Light 16, Tables font Segoe UI 10. It will not adjust bold or other styles leaving them intact.

    Proofing Language -> Dutch (NL)

    244

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

    Resize + Perfect Print

    235

    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.

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

    233

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

    Crear título fecha

    232

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

    Link to Google

    228

    Select text and hyperlink to directly google search page. A child of the macro "Text to Web Search Link". Try "Set a reminder after 5 minutes" type commands too.

    Resize Images Android

    227

    Resizes each image to good size for Android app

    Fit printout images - for entire section

    221

    Fit printout images to page widht and place them in the top of the page. It will consider RTL page setting. If you import an 8.5x11 page from a printout (Ex. from a PDF) into OneNote, this macro will fit the image to the page widht and also set the image to background, making it ready to annonate and easily print out to paper if necessary. 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.

    Append Desired Text to All Page Titles

    219

    Appends given text to all page titles in either the current notebook or all notebooks

    Template Litigation Notebook

    217

    Creates sections for the LawToolBox Template Litigation Notebook. It is recommended that you create an empty notebook and then run this macro while in that notebook.

    Insert REVERSE

    217

    Inserts text string REVERSE with red background and white font color

    Search & Replace in Section Names

    213

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

    Proofing Language Page -> German (CH)

    213

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

    *Prepend Page Date to Title (Custom)

    212

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

    [Interview] tag & text

    208

    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

    Add Hyperlink to Text

    206

    Search for instances of given text and add the given hyperlink to them assuming their font size is less than the given limit. NOTE: If you want to link to the non-web version of OneNote you must copy the hyperlink from the object you want to link to, paste it into OneNote, then copy the link from that hyperlinked text.

    [PDF] tag & text

    206

    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

    Enumerate Hyperlinks Folder Name

    200

    Enumerates selected file hyperlinks source url folder name allowing it to be subsequently copied into windows explorer to quickly navigate to that folder. This avoids having to edit the hyperlink and remove embedded html codes. The folder name is appended as text selected, ready for you to copy. See a demo of the macro in action at https://youtu.be/Mc_WpnVOcr4. If you find this macro useful please donate to http://www.paypal.me/SimonRear to encourage the development of more useful timesavers.

    List pages with a given name

    199

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

    code

    198

    Changes selected text font to Consolas size 10

    Remove Empty Lines from Selection

    188

    Removes empty lines from Selection (moves them to the bottom)

    Prepends Create Date *yyyymmdd* to Title

    184

    Build with code from "Prepend Creation to Title" by Jim and "Capitalize Page Titles" by Omer Atay. Function: Prepend the creation time in yyyymmdd format to titles of pages under selected scope. If the title already has date in other format, such as yy/mm/dd, the old date will be updated to the yyyymmdd format. Note, if the title star with number,"/", or "-", it will be replaced as well.

    Generate Random String

    183

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

    SetstatusRecycle

    177

    Sets background of currently selected to orange

    Set Container Width manually

    172

    Sets the container size

    Insert DD/MM/YY and DayOfWeek

    170

    Insert DD/MM/YY DayOfWeek

    All Page Font Meiryo UI Size 10

    167

    All fonts change to Meiryo UI black size 10, Titles to Font Size 20. 1 page effect

    Proofing Language Page -> Polish (PL)

    165

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

    Set Page Level to 1 for All Pages in Section

    165

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

    Set Section Container Width 618

    162

    Sets the container size

    Set Page Level to Two for All Pages in Section

    162

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

    Search & Replace in Section Group Names

    161

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

    Font -> Consolas 11pt

    159

    Changes font to Consolas with size 11pt on current pages

    Clark_Code

    159

    代码格式:代码Courier New12号斜体

    Add *yymmdd* + sort latest page on top

    155

    1. Add *yymmdd* as title prefix for all Notes in Section 2. sort latest page on top ***Note: automatically skip Notes already prefixed. If note has no title, automatically use first line or add "Untitled Note"

    Proofing Language -> English (US)

    155

    Sets the proofing language on selected text to American English

    Select Between First two Heading 1

    155

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

    All Section Font Meiryo UI

    155

    All fonts change to Meiryo UI, Titles to Font Size 20

    Set Proofing Language to en-gb or pl-pl

    154

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

    Title > 黑体 15.5

    151

    修改当前页面标题的字体为黑体,字号为 15.5。

    [Panel Discussion] tag & text

    150

    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

    Attendance tag dimmer

    146

    Dims in attendance tags for the selected scope

    Replace SmartQuote

    144

    Find & Replace smart quotes from Microsoft word

    Add Collmex Link

    141

    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.

    Template SCorpBooks Notebook

    140

    Creates sections for the LawToolBox Template SCorpBooks Notebook. It is recommended that you create a new empty notebook and then run this macro while in that notebook.

    Proofing Language Text -> Polish (PL)

    140

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

    Prepend Creation to Title (yymmdd)

    137

    Extension from Jim's popular Prepend Creation Title. This version prepends created date to *yymmdd* instead of *yyyy-mm-dd*. Trick 1: Write your first line as title. Trick 2: Use Quick Access Toolbar so that you can use Atl + then Enter to quickly add to title

    Fit printout A4 to A3 page - for entire section

    137

    Fit printout A4 pages to right side of A3 landscape pages (if the page not set to landscape, it will set it) . It will consider RTL page setting. If you import an A4 pages from a printout (Ex. from a PDF) into OneNote, this macro will fit it to the page and also set the image to background, making it ready to annonate and easily print out to paper if necessary. 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.

    Add *yymmdd* as Note title prefix for all Pages in Current Section

    135

    Add *yymmdd* as Note title prefix for all Pages in Current Section. Usage: select desired Section to add *yymmdd* before running macro. If Page already starts with 20** or 18** then that note will be skipped. If Page does not have the title: the first line will become the title -> trick: don't bother naming your note. Just type the first line with your intended title. Then run this macro once after every while.

    Append Date to Title (dd.mm.yy) Wetter

    134

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

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

    133

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

    Proofing Language Text -> German(AT)

    132

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

    Clark_Title

    129

    标题格式:中文宋体,英文Times New Roman,20号粗体

    Append Date to Title (dd.mm.yy) Titel

    129

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

    Font -> Arial 12

    128

    Changes selected text font on current page to Arial and font size 12 to indicate code parts

    Proofing Language Page -> Spanish (ES)

    125

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

    All Section Font Meiryo UI Size 10

    125

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

    Add/Remove Date/Time from Titles

    125

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

    Add *yymmdd* as Note title prefix for all Pages in Current Section

    125

    Add *yymmdd* as Note title prefix for all Pages in Current Section. Usage: select desired Section to add *yymmdd* before running macro. If Page already starts with 20** or 18** then that note will be skipped. If Page does not have the title: the first line will become the title -> trick: don't bother naming your note. Just type the first line with your intended title. Then run this macro once after every while.

    Date Modifier for Imported Email from Outlook

    124

    This macro is essentially a modified version of the "Outlook Email Date Stamp" by Omer Atay and JasonDaSilva. The modification is that the user prompt is in french and the macro works for e-mails in french and german e-mails. It should also work for italian but it wasn't tester. Description of the original macro: "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."

    Font -> Courier New 10

    124

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

    Insert Subpages with Selected Texts As Titles

    122

    For all selected text items - Insert new subpage at section bottom, crosslinked to starting page

    Proofing Language -> Czech (CZ)

    119

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

    Append Date to Title (dd.mm.yy) Datum "Angebot" Titel

    117

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

    2. Red Toggle

    114

    Changes selected text font to

    Proofing Language -> Slovenian (SLO)

    113

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

    Proofing Language -> Danish

    108

    Sets the proofing language on selected text to Danish

    Proofing Language -> Swedish

    106

    Sets the proofing language on selected text to Swedish

    List Notebooks with Deleted Pages

    104

    OneNote has difficulties to sync books on IOS devices that have content in the recyling bin. This marcro helps to identify books that have deleted content. Creates a page with a list of all open notebooks and displays the number of deleted pages. A link to the notebook is created to navigate the book.

    Samy --> InsertRow

    104

    Sample macro showing how to rearrange rows in a table

    六爻排版

    102

    对六爻卦象进行排版

    BG: transparent

    101

    Highlights a text transparent.

    Insert Time Stamp PEJ v.2

    100

    Insert MM-DD-YYYY HH:MM (bold, italic and gap)

    Clark_Text

    99

    正文格式:中文宋体14号,英文Times New Roman14号

    MultiplyTwoCells

    99

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

    Set Image Width

    98

    Set image width (and height in proportion as well) and keep the image "sizeSetByUser" property false.

    Randomize Table

    96

    Randomize the order of the rows of a table, excluding the header. This is useful to many GMs to "roll" on random loot tables and such.

    3. Blue Toggle

    88

    Changes selected text font to

    1. Black Toggle

    87

    Changes selected text font to

    Insert Link To Parent Page

    75

    Insert link to parent page in upper right corner. Works only for sub-pages.

    Proofing Language Page -> Bulgarian (BG)

    75

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

    Set rpm Indenting+Style

    75

    Sets for each outline left offset 36p (default) and width=1000p + Makes cascade indenting: - greater header level has greater indenting level - text under header has indenting greater by one than header

    Insert Line Before Headings

    66

    Insert a blank line before Heading 1, 2 and 3.

    Set rpm Indenting

    65

    Makes cascade indenting: - greater header level has greater indenting level - text under header has indenting greater by one than header

    Proofing Language Text -> German(CH)

    64

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

    Uncheck All Todos in Cells

    63

    Uncheck all todos contained in cells. Useful if you have many todos on one page and some must not be unchecked. For example, if you have a weekly calendar with todos you must do each day, and separate todos that don't need to be done on a specific day. I put my daily todos in a table and the other todos outside of the table. This marco unchecks only the todos in the table (in cells).

    Proofing Language -> Swedish

    63

    Sets the proofing language on selected text to Swedish

    全页CY

    61

    Changes text font to Consolas-Yahei, A font type combined both Consolas as English and Yahei as Chinese

    Complete all uncompleted tags in page

    61

    For each tag in page, set to completed if it is not completed

    Samy --> 9.toggle HL yellow

    60

    Changes selected text font to

    Set Text Color

    60

    Changes text color to a three-pair RGB hexadecimal value where each pair is a 2 digit value between 00 (off) to FF (full intensity). For example, to change text to full intensity RGB red, one would enter FF0000. For full intensity green, one would enter 00FF00. For blue, one would enter 0000FF. Any RGB combinaison is thus possible.

    Sample - Insert Bold Text Then Place Cursor After a Space

    57

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

    Proofing Language Text -> Croatian (Hr)

    57

    Sets the proofing language on selected text to Croatian (Hr)

    Samy --> 3.blue bold

    57

    Changes selected text font to

    Samy --> 8.toggle HL aqua

    57

    Changes selected text font to

    Set rpm StandardStyle

    55

    Sets for each outline left offset 36p (default) and width=1000p

    Samy --> 2.red bold

    55

    Changes selected text font to

    Demarca Lineas Tamaño Carta

    54

    Agrega lineas de color gris suave para delimitar el tamaño de una carta en el modo de tamaño Automático o Infinito.

    Proofing Language Page -> Croatian (Hr)

    52

    Sets the proofing language on selected page to Croatian (Hr)

    Samy --> 7.toggle HL purple

    51

    Changes selected text font to

    Samy --> 5.toggle HL Off

    50

    Changes selected text font to

    Toggle between en-US and fr

    50

    Toogle proofing language on selected text between en-us and fr

    Samy --> 4.toggle bold

    48

    Changes selected text font to

    Distribute Columns

    44

    Distribute the width of the selected columns equally between them. This macros is similar to the command of the same name in Microsoft Word.

    Samy --> 6.toggle HL grey

    43

    Changes selected text font to

    Proofing Language -> Portuguese (Brazil)

    43

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

    Samy --> 1.Consolas

    41

    Changes selected text font to Consolas size 10

    Count Selected Rows

    40

    Count the selected rows and shows the result in a message box.

    Proofing Language -> Slovak (SK)

    39

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

    Sum Hours in Page Titles of Current Section

    34

    Sum hours contained in page titles of current section and display the total in a dialog box. Optionally, create a new page with a detailed report. Hours must be between parentheses and be at the end of the page title. For example: This is my page title (7.5)

    Unlock Column Width

    18

    Unlock the column width of the selected columns so that their width adjusts automatically based on content.

    Proofing Language -> Italian

    12

    Sets the proofing language on selected text to Italian (it-IT)