Macroland

Macroland currently has 618 macros by 335 authors

Sort By:

Macros by: Omer Atay

Insert Monthly CalendarCalendar by Omer Atay, that0n3guy Inserts a calendar of the selected month and year Last Updated: October 25, 2020		Sort Pages Sort Sort each page in current section by name, sub pages stay under their parent pages and sorted among themselves
		TOC in Current Notebook TOC Creates or updates table of contents of the current notebook
		Search & Replace Find Search and replace text in the current page, section or notebook
TOC in Current Page TOC Creates a table of contents from heading in the current page and inserts at the top of the page. Optionally it adds "Back to Top" links to the headings.	Insert Horizontal Line Horizontal Line Inserts a horizontal line	TOC in Current Section TOC Creates a new page with table of contents of the current section
Weekly Planner Calendar Inserts page with a section for each day in the current week	Sort Sections Sort Sort each section in current section group by name	Resize Images Image Resizes each image and printout in the current page by given percentage. This extension allows to choose either all images or the selected image only on the current page to be resized.
Sort Pages By Date Sort Sorts pages in current section or notebook by created or last modified date	Sort Notebooks Sort Sort notebooks by name	Blackboard page Background Changes the background color of the page to black, sets all font to white, and optionally removes date/time under title
Daily Planner Page (Today) Calendar Planner with Task List and a Daily Notes page. This will create a single page with today's date on it.	Function Table Use sum, average, etc. functions on tables. Select a cell, a column or a row to apply the functions.	Word Count Info Displays the number of words and characters on the page
List Notebooks TOC Creates a page with a list of all open notebooks and links to them	Search & Highlight Find Search and replace text in the current page, section or notebook	Text to Table Table Converts selected text into table
Insert Yearly Calendar Calendar Inserts a calendar of the selected year	Where am I Navigation Inserts a breadcrumb showing where the current page is in the hieararchy of notebooks / section groups / sections	Set Page Background Color Background Pick a color to set the page background
Insert Double Horizontal Line Horizontal Line Inserts a double horizontal line	Tag Summary for Specific Tag Tags Creates a tag summary page for a specific tag. Up to three tags can be specified to find paragraphs that contain all those tags together	Weekly Planner for each day with Done&TODO Calendar Inserts page with a section for each day in the current week with Done, Problem and TODO.
Sort Table Sort Sorts selected table by selected column	Set Section Color Color Sets Section Color to selected color	Attachment List Embedded Files Creates a list of attachment filenames in current section, section group or notebook. Provides page names and links back to the page and the embedded files.
UPPER CASE Change Case Convert selected text to upper case	Recent Edits History Displays a summary page of recent edits in current section/section group/notebook or all notebooks	Number of Pages Info Displays number of pages in current Section/Section Group/Notebook/All Notebooks (Excludes Recycle Bin)
Increase Font Size Font Increases font size of all text on the page by 1	Auto-fill Table Auto-fills selected table cells using data from the first few selected cells	Select Images Image Selects all images on the page
Capitalize Each Word Change Case Capitalize each word in the selected text	Sublime Theme Background Makes the background color of the page dark gray and converts existing text to white. Based on the Sublime text editor. Note: Does not force the Automatic Font to White. Pending fix.	Decrease Font Size Font Decreases font size of all text on the page by 1
lower case Change Case Convert selected text to lower case	Sort Selected Paragraphs Sort Sorts selected paragraphs or list items	Clean Hyperlinks Content Removes all friendly hyperlinks in the current page
To-Do List with Page Names Tags Creates a page at the top of the section that lists all un-checked To-do tags. It is titled "TO-DO List (yyyy-mm-dd h:mm)".	Tag Summary with Page Names Tags Creates a tag summary page with page names and links for each tag. Orders the results first by tag, then by the page they appear in.	No Spell Check Spell Check Removes spell check (red squiggles) from selected text
Diary Pages Pages Create a page for each day in the selected month with date of the day as the title	Where am I + Navigation Inserts a breadcrumb showing where the current page is in the hieararchy of notebooks / section groups / sections / Parent Pages. Automatic remove the old breadcrumb.	Create Task Cards Content Create tasks cards on the page
Clean Authors Content Cleans author information from the current page	Sort Selected Todos Sort Sort Todo boxes by checked/unchecked. Select the paragraphs that have todo checkboxes and run this macro.	Code mode Code Changes the text style to code (Consolas 10 pt, with a very light background, reminiscent of Evernote Code Blocks). Works even when no text is selected.
Outlook Email Date Stamp EMail This macro will change the creation date of each page in the current section with the time the email was sent, allowing them to be sorted by the email date. This has been made specifically for emails sent to OneNote from Outlook.	Show Month Calendar This macro will draw a month calendar for the specified month. The events are the titles of pages form one or two sections in the same notebook, based on teh dateTime for the page. A page whose title has a tag will show the tag instead of the time. Each calendar event links to the relevant page	Tag Complete & Strikethrough Tags Completes the Todo tag and strikes through the selected paragraph
Capitalize Titles Change Case Capitalizes the first and last word of a selection and any other words longer than 3 letters	Set Notebook Color Color Pick a color to set the current notebook color	tOGGLE cASE Change Case Toggle casing of selected text
Monthly Planner Pages Content Creates a Monthly Planner page for each day of a month or for each month of the year	TOC in All Notebooks TOC Creates a new page with table of contents of all notebooks	Search & Replace in Hyperlinks Find Search and replace in hyperlink URLs in the current page, section or notebook
Remove Paragraph and Line Breaks Content Removes paragraph breaks and line breaks on selected paragraphs and merges them into a single paragraph	Sort Pages Ascending Sort Sort each page in current section by name in ascending order, sub pages stay under their parent pages and sorted among themselves	Insert Subpage With Selected Text As Title Pages Inserts a new page at the bottom of the section and makes it a subpage and makes the selected text the title. It also creates a link back to the original page.
Insert Horizontal Line between Paragraphs Horizontal Line Inserts a horizontal line between each of the selected paragraphs	Search & Select Find Select search terms in the current page	Insert Time Stamp Date/Time Insert YYYYMMDD-HHMMSS
Custom Rule Lines Rule Lines Set spacing and color of grid lines to any value.	Daily Manager Log Content Creates a Daily Manager Log page for each day in the whole year or a month	Insert Page at the Top Pages Inserts a new page at the top of the current section
Tag Complete & Add Date Tags Completes the todo tag on the selected line and adds the current date/time to the end of it	TOC in Current Section Group TOC Creates a new page with table of contents of the current section group	Add icon to page title Content Adds an icon (emoji) to the front of the title, for easy reference of page type. For example, use "✉" as the first character to easily identify pages created from emails.
Title -> Calibri Light 20 Font Changes title of each page in the current section to Calibri Light 20 to match OneNote 2013 style	Resize Images by Pixels Image Resizes all images image and printouts in the current page to a specified image size.	Select Done Tasks Content Select all done tasks on current page for easy deleting (just hit delete key).
Clean Timestamps Content Cleans timestamp information from the current page, typically added by Insert Screen Clipping command	Vertical Spacing Containers This will make all selected content containers equaly spaced away from each other, Enter into the dialog box how much you want the spacing to be.	Collapse Parent Outlining Collapse parent outline element
Tag Completion Date Tags Displays the completion date/time of the To Do tag on the selected paragraph	Insert legal symbol Symbols Inserts a legal symbol (one of Δ, Π, §, §§, ¶)	Set Page Date & Time Pages Set the page date and time to desired time
Collapse Pages in Notebook Navigation Collapse all pages in the current Notebook	Search & Tag Find Find a search term and create tags in matching paragraphs in the current page, section or notebook	Table to Text Table Converts the selected table to text, columns separated by tabs. Preserves formatting but will remove any images
Extract highlighted Text Text Extracts any highlighted text and prints it at the end of the page	Insert Subpages With Selected Paragraphs As Title Pages Inserts a new page at the bottom of the section for each paragraph selected in the current page, using it as a title	New Meeting Content Insert a small string of text with an automatic date & author. Ideal to start a new meeting.
Select Text With Similar Formatting Formatting Selects all the text in the current page with similar formatting to the currently selected text	Uncheck All Todos Tags Uncheck all todo boxes on the current page	Move Page to Top of Section Page Ordering Moves the current page to the top of the section
Collapse Pages in Current Section Group Navigation Collapse all pages in the current Section Group	Prio Sort This macro is to sort a prioritized To Do list, colors them based on priority and status. You need to select the To Do list to sort them. Indented sections are treated as one, and sorting will not harm them.	Insert Dated Page at the Top Pages Inserts a new page at the top of the current section with title as date
Collapse Pages in Notebooks Navigation Collapse all pages in all Notebooks	Dim Tags Tags Dims tags on the current page so that they don't show up in tag search results	Sample - Create tables Samples Creates sample tables in the current page
Sentence Case Change Case Capitalize the first letter in each sentence in the selected text	Create pages from list of titles Pages Creates pages in the current section from a given list of titles separated by comma (;)	Go to end of the page Navigation Moves the cursor to the end of the page
Letter sized paper with infinite length and ruled horizontal lines Rule Lines Adds a vertical rule line to a letter sized paper with infinite length and ruled horizontal lines. You can change the rule line color afterwards from View > Rule Lines > Rule Line Color if you want.	Undim Tags Tags Undims tags on the current page so that they show up in tag search results	Shade Alternate Table Rows Table Shades alternate rows of selected table to the selected accent color
Recent Edits with Author Info History Displays a summary page of recent edits in current section/section group/notebook or all notebooks with author info that made the edits and date	Page Template Name Info Displays the original template used to create the current page	List hyperlinks from search in new page (choose scope) Find List hyperlinks from search in new page
Sort Paragraphs and Remove Duplications Sort Sort every paragraph on the page exclude empty ones and title. And also delete duplications.	Copy Current Page to Other Notebooks Pages Copies current page to other notebooks. Only copies text content. You can select one or more target notebooks, or pick all notebooks.	Number First Cells Table Numbers only the first column in a table starting from a given value.
Remove All Indents From All Paragraphs Formatting For every paragraph, it will sent the indent to nothing	Sort by Tag Sort Sort selected paragraphs by their tag name	Create sections from list of titles Sections Creates sections in the current notebook (or section group) from a given list of titles separated by semicolon (;)
Insert Short Date Stamp Date/Time Insert "YYMMDD - "	Sample - Insert Tags Samples Inserts all possible tags on a new page	Transpose Table Table Transposes the selected table. It may leave empty cells if the table is not a square. It only works if the table has text. Non-text content will be lost.
Print/SaveAs SimpleHelper - Grid 0.5" on LetterPaper Pages First, manually apply Letter size w/ margins T&B 0.5" and L&R 1". Then, run this macro to see the "ideal"printable-area if scale-down is not applied. See the comments in Macroland for more information.	Change Text Color Color Change color of all instances of text within the given scope that match the given inputs. Required Inputs: hex code of desired color, Scope, Case sensitivity Optional Inputs: Text to Color, Target Font Name, Target Font Size, Various filters NOTE: Either Text to Color or Target Font Size must be provided, both may also be provided for additional specificity.	Capitalize Page Titles Change Case Capitalize titles of pages under selected scope
Sample Insert Text Samples Inserts text at the current position	Add/Remove Date/Time from Titles Title Adds or removes Date/Time from titles of pages in current section or notebook	Sample Notebook/Section/Page Picker Samples Sample macro showing how to allow user pick a notebook, then a section, than a page
Sample - Create a new page Samples Creates a new page in the current section with given title and some text content	Go to the begining of the page Navigation Moves the cursor to the beginning of the page.	Search & Replace in Titles Find Search and replace text in titles of pages in selected pages, current section, notebook or all notebooks
Add Footer to All Pages Content Adds the given text to the end of all pages in the current section	Insert Space Between Paragraphs Content Inserts an empty paragraph between each of the selected paragraphs	Sample Create Section Hierarchy Samples Creates a sample section group/section hierarchy
Highlight Hashtags Formatting Highlights hashtags (#word)	Template Notebook Structure Templates Save section hierarchy of current notebook (not pages) into a templates store and later apply those templates to new notebooks. Create a new empty notebook to apply templates.	Replace Line Breaks with Paragraph Breaks Text Replaces line-breaks (inserted with Shift+Enter) with paragraph-breaks in selected text
Fix Printout RedX Issue Workarounds Worksaround a bug in OneNote 2016 where prinouts will show up as red X on other clients. This macro runs on current notebook and fixes all such pages.	Set Container Width manually Content Sets the width of all container on the current page to given number of points	List Password Protected Sections Sections Lists the password protected sections in the current notebook or all notebooks
MultiplyTwoCells Table Multiply two cells of a row or a column into a adjoining empty cell in a table	Find Table Rows with Search Term Find Searches for a term in the current notebook in tables and outputs the found whole table rows into a new page	Sample - Custom Sort Notebooks Samples Sort notebooks by after the first 6 characters of name
Sort Rows by Tag Sort Sorts the rows of the selected table based on the first tag in the first cell of each row	Template Litigation Notebook LawToolBox Creates sections for the LawToolBox Template Litigation Notebook. It is recommended that you create an empty notebook and then run this macro while in that notebook.	Collect Clipped URLs Hyperlink Collect clipped URLs from current section or notebook
Format Numbers Formatting Applies specific formatting to all numbers in the selection or the current page	List pages with a given name Pages Creates a new page with a list of all the pages in the current notebook that has a certain name	Search & Replace in Section Names Find Search and replace text in section names in the current section group, notebook or all notebooks
Sort Paragraphs by Highlight Color Sort Sort selected the paragraphs by the highlight color on them. You can use this after using "Extract Highlighted Text" macro to sort the extracted text by highlight color	Color VB Comments Formatting Changes color of text starting with a single quote (') on selected lines to green	Search & Replace in Section Group Names Find Search and replace text in section group names in the current notebook or all notebooks
Reformat Quick Paste text and URL into a hyperlink (text in BOLD) Content Select pasted text name (must be bold) and link from YouTube video name and link, then reformat in only one line reduced format	Template SCorpBooks Notebook LawToolBox Creates sections for the LawToolBox Template SCorpBooks Notebook. It is recommended that you create a new empty notebook and then run this macro while in that notebook.	Sample - Move Last Row To Top Samples Sample macro showing how to rearrange rows in a table
Generate Random String Content Generates a random string of 10 characters and inserts it to the current page	Sample - Insert Bold Text Then Place Cursor After a Space Samples Inserts bold text at the current position, then adds a space and places cursor after that	Title -> Times New Roman 20 Font Changes title of each page in the current section to Times New Roman 20
Proofing Language -> Portuguese (Standard) Proofing Sets the proofing language on selected text to Portuguese (Standard)	Font -> Times New Roman 12 Font Changes selected text font on current page to Times New Roman 12pt	Copy Plain Text Link to Current Page Hyperlink Displays the onenote: link for the current page so that you can copy it and paste it into an application that only accepts plain text. Built-in Copy Link to Page feature in OneNote would copy the link in HTML format.
Select Between First two Heading 1 Content Selects all content between the first and the second Heading 1 styled paragraphs in the current page	Reformat Quick Paste text and URL into a hyperlink (YT tam18) Content Select pasted text (default text size 18) and link from YouTube video name and link, then reformat in only one line reduced format	Replace Paragraph Breaks with Line Breaks Text Replaces paragraph breaks in selected paragraphs with line breaks. Line breaks can be manually inserted using Shift+Enter.
Set Page Date to Today Date/Time Sets the creation date of the current page to current date/time	Small-Caps Titles Change Case Capitalizes the first and last word of a selection and any other words longer than 3 letters - all others are set to capitals but 4 sizes smaller to emulate small caps.	Green Text Color Sets font color to green
Insert Page Created Date in ISO format Date/Time Inserts the page created date in ISO format (YYYY-MM-DD HH:MM)	Sample - Insert Styled Paragraph Samples Inserts a paragraph for each built-in OneNote style into the current page	Proofing Language -> Slovak (SK) Proofing Sets the proofing language on selected text to Slovak (SK)
Convert "LN, FN" to "FN LN" in Meeting Notes Content In meeting notes if there are attendees in the format "LastName, FirstName", this macro converts them to "FirstName LastName" format.	Remove Line Breaks Content Removes line breaks on selected text