macroland Macroland

Most Recent Macros

Set Column Widths
Sets the column width of the selected table on the current page to the specified value.
Auto Generate Links to Pages
Automatically creates hyperlinks on any text that matches a page title within the section
Text to Table
Converts selected text into table
Paragraph Spacing = 3
Sets paragraph spacing to "0" spaceBefore, "7" spaceAfter, and "0" spaceBetween.
Search & Replace
Search and replace text in the current page, section or notebook
Set Table Colors
Set selected Table Shade for Odd and Even Lines
Remove Footnote
Removes the selected footnote and associated links
Add Footnote
Adds a footnote to the bottom of the page and links the current cursor position with the footnote. If there is any text selected, it is moved to the footnote
TOC in Current Page
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.
Sort Sections by Last Modified
Sort sections of a notebook based on when they were last modified. Most recent sections are shown first.
Make Blank Annual Journal
Select any year between 2013 and 2028 and this macro wil create a Journal for you. Each month is a section, and each month has a page per day, There is also a calendar tab that you can use the "Insert Calendar" macro to fill (I may later extend the macro to do that automatically, and also remove the New Section that is created when you open a new notebook). Future years extensions are a matter of adding a handful of new statements in the macro, but everything in OneNote may have changed by then, so I'll defer that one for now.
Add URL to label of links
For each link in selected scope, adds its URL to the display text
Daily Planner Page (Today)
Planner with Task List and a Daily Notes page. This will create a single page with today's date on it.
Sort Pages By Date
Sorts pages in current section or notebook by created or last modified date
Sort Pages
Sort pages in current section or notebook by name, sub pages stay under their parent pages and sorted among themselves
Create Page With Completed Tag Summary
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.
Spell Check off for Courier - Page
Turns Spell Check off for any text in the open page with the Courier New font.
Spell Check off for Courier - Notebook
Turns Spell Check off for any text in the open notebook with the Courier New font.
ALL Page Titles -> Calibri 20
Updates the Titles of ALL Pages in ALL Sections of the Current Notebook to Calibri 20 to match the OneNote 2019 title style.
Dark grey background with green font
Give a single page dark grey background and change the fonts to green
Insert Date Updated
Insert "Updated: at the cursor position.
Set Font 나눔고딕 11
All fonts in current page change to 나눔고딕 size 11
Insert YYYYMMDD - Long Date as Title
Insert YYYYMMDD - Long Date as Title, eg ... 20210913 - Monday, 13 September 2021 (based on other macros, thanks to Insert ISO yyyymmdd - at the beginning of the page and insert long date macros)
Proofing Language -> Ukrainian (UA)
Sets the proofing language on selected text to Ukrainian (UA)
Link Text on Page to Page Titles in Selected Section
Macro that allows you to link text on a page to a selected section's pages with matching page names
Show Month
This macro will insert 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 the creation time 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.
Paragraph Spacing = 9
Sets paragraph spacing to "0" spaceBefore, "0" spaceAfter, and "9" spaceBetween.
Gather TO-DO tags on new page with description, links and creation date
Creates a page at the top of the section that lists all un-checked To-do tags. It is titled "TO-DO".
Proofing Language Page -> German (AT)
Sets the proofing language on selected page to Austrian German
Insert page create short format date time at selection, cursor
Insert page create short format date time at selection/cursor ('YY.mm.dd ddd)
OneNote转为MD格式
个人用onenote自动转为markdown格式的宏 1.缩进用“   ” 2.表格不会被缩进影响 3.加粗字体转为md格式 4.字体颜色用font标签标记
Rosa Cor de pele
Define o Background da página como rosa cor de pele.
Simple 365 days
create 365 pages Month = Section
Rainbow your notebooks and sections
This macro will color all your notebooks and sections as a rainbow. Feel free to enter the macro and modify the color array (also the if statements)
Custom Java Display Code
Converts the selected highlighted text. Reformats it with line numbering and code background highlightin.
Resize Images Larger Than
Resizes all images and printouts in the current page larger than specified to the specified image size. Useful for when you want to shrink the container, but one or more images are preventing it from becoming smaller.
Number Pages
Adds numbering to the page titles in the current section. If the pages already have numbering it will update it
Text To Code V1.1
Takes code pasted from an IDE and makes a code like block, preserving color and disabling the spell check.
Noto Sans TC Medium
Change font to Noto Sans TC Medium
Clean Authors (Select Scope)
Cleans author information on selected lines, in the current page, section, section group, notebook or all notebooks
Advanced Table Numbering with Prefix
Set a Prefix with numbers. Variable start number and increment.
Add icon to all meetings
This macro will change the title of each page in the current section to add a meeting emoji to the beginning (unless it already has one). This has been made specifically for meetings sent to OneNote from Outlook. Great from seeing all meetings in a section at a glance.
Custom Display Code
Converts the selected highlighted text. Reformats it with line numbering and code background highlightin.
Tag Summary for Specific Tag
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
Format standard table page images
Recommended for use on a page containing a 2-column table of images. Standardize the width of all images, table columns, and containers on the current page. All images are resized to width of 360 while maintaining aspect ratio. All table columns are resized to width of 50 unless an image in that column prevents it from shrinking lower than 360. All containers are resized to width of 730 unless otherwise restricted.
Number of Pages
Displays number of pages in current Section/Section Group/Notebook/All Notebooks (Excludes Recycle Bin)
Remove Line Breaks
Removes line breaks on selected text
Monthly Planner Pages
Creates a Monthly Planner page for each day of a month or for each month of the year
Collapse Pages in Current Section Group
Collapse all pages in the current Section Group
Sentence Case
Capitalize the first letter in each sentence in the selected text
TOC in Current Notebook
Creates or updates table of contents of the current notebook
Diary Pages
Create a page for each day in the selected month with date of the day as the title
All Section Font HelveticaNeue - Titles HelveticaNeueLT Com 65 Md 20, Texts HelveticaNeueLT Com 65 Md 11
All fonts in current section change to Calibri. Titles to Calibri Light, font size 20. Texts to Calibri, font size 11.
Prepend Short Creation Date to Title ('yy.mm.dd ddd)
Prepend create date "'yy.mm.dd ddd" to title
Small-Caps Titles
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.
Insert Monthly Calendar
Inserts a calendar of the selected month and year
Title -> Arial Black 20
Title in Arial Black 20
All Page Font Arial Size 11
All fonts change to Arial size 11, Titles to Font Size 20. 1 page effect
当前页面目录
This is a Chinese version of TOC in Current Page. I only changed the title "Table of Content" to "目录" and "Backtotop" to "页首", which might be more suitable for Chinese users. 只是把TOC in Current Page这个宏的目录标题从 "Table of Content"改成了“目录”,把“Backtotop”改成了“页首”对于中文的页面可能更友好一点:-)
All Page Font Calibri Size 14
All fonts change to Calibri black size 14, Titles to Font Size 20. 1 page effect
分别设置中英文字体
如果选中部分文本,则只对选中部分进行修改,否则对当前页面所有文本修改。 默认中文设为“宋体”,英文设为“Times New Roman”。如果需要更换其他字体,可以编辑这个 Macro,分别设置 cnFont 和 enFont 为自己想要的字体即可。 ;如果需要统一设置字体大小也可以设置变量 fontSize 的值。 关于 OneNote 设置中英文字体,如需了解更多,请移步 http://t.cn/RT8Imz9 ,欢迎一起讨论。 (PS:大家如果遇到什么问题,或有什么其他需求可以给我留言(请留下联系方式,以便通知您),或直接发邮件到 wenmin92@gmail.com,也可以添加微信 wenmin92)
Remove Numbering
Remove numbering from begining of every line in text
Resize all Images on Page to One Standrad Width
Resizes all imagen on the current page to a given, equal width.
Daily Eisenhower Matrix Eisenhower Matrix Daily Tasks Agenda Calendar
One page per day with Eisenhower Matrix Task List on each page
See All Macros