Macros

Welcome to the Macro page where you can access all of Leverage & Lean’s macros. 

Ready for Less Clicks, More Results!? Start using Leverage & Lean macros today!

Simply use the search feature to find cards of content.  Embedded in these cards are macro instructional videos that help you customize Leverage & Lean macros to meet your individual needs. If you need assistance making changes let us know how we can help.

If you have a custom macro in mind subscribe as an Insider and we will build it for you!

Insider

Excel Selection as Filter Criteria | VBA Macro #79

Filtering through large sets of data can be a challenge especially if you are looking to only apply a subset of filter selections through 100s of selections options. Good news is there is a better way with VBA when using the Leverage & Lean Excel Selection as Filter Criteria macro! This Excel macro will reference your current selection and use the contents of this range as the filter criteria.

Read More
Insider

Outlook Create Email for each Attachment | VBA Macro #78

While there is an open debate about how to run more effective meetings, we can be inefficient in providing our availability to get meetings scheduled. This is no longer the case with Leverage & Lean’s Outlook Quick Text of Calendar Availability macro! This Outlook macro will prompt you with a series of questions that will help you quickly gather the weekdays and times you are available to schedule a meeting. After these questions are answered to current Outlook email will be populated automatically with the series of weekdays (with date formatted MM/DD/YYYY), available times and duration of when you are available to meet. With this text now in the Outlook email body you can make your final adjustment removing times that shouldn’t appear. The Quick Text of Calendar Availability Outlook macro provides a standardized way of providing your meeting availability consistently each time! No longer will it be necessary to type out all this information which can be an annoying undertaking when your desire is to move on to a task that provides more value.

Read More
Insider

Outlook Quick Text of Calendar Availability | VBA Macro #77

While there is an open debate about how to run more effective meetings, we can be inefficient in providing our availability to get meetings scheduled. This is no longer the case with Leverage & Lean’s Outlook Quick Text of Calendar Availability macro! This Outlook macro will prompt you with a series of questions that will help you quickly gather the weekdays and times you are available to schedule a meeting. After these questions are answered to current Outlook email will be populated automatically with the series of weekdays (with date formatted MM/DD/YYYY), available times and duration of when you are available to meet. With this text now in the Outlook email body you can make your final adjustment removing times that shouldn’t appear. The Quick Text of Calendar Availability Outlook macro provides a standardized way of providing your meeting availability consistently each time! No longer will it be necessary to type out all this information which can be an annoying undertaking when your desire is to move on to a task that provides more value.

Read More
Insider

Excel Sort All Worksheets | VBA Macro #76

It is refreshing to see open an Excel Workbook and see all the worksheets in order.  This isn’t just refreshing but is powerful as you don’t have to waste time navigating looking for a worksheet. Being organized allows you and your colleagues to work quickly and with little effort.   This is in part of why Leverage & Lean created the Excel Sort All Worksheets macro.  This Excel macro will look at all available Excel Worksheet names and sort them in order.  Whether you are managing an Excel Workbook with names or numbers the Excel Sort All Worksheets macro will help you stay organized and allow you to focus on the work at hand.

Read More

Outlook Select Send Using Account | VBA Macro #75

If you are using multiple account in Outlook, you may find yourself forgetting who you are sending from which can be confusing for your team and worst your clients. To mistake proof the send from selection Leverage & Lean has created the Outlook Select Send Using Accounts macro! This Outlook macro will look at all your available Outlook Accounts and display them in an InputBox for you to select from. To select an Outlook Account just enter the leading number into the InputBox. This Outlook macro will then adjust your Sending Using Account to reflect the selection that you have made. While you can do this with an email open it is easy to forget to make this selection. The power of this macro is that you can create custom button to prompt you prior to creating, replying or sending an email in Outlook. You can take this a step further and embed the Outlook Select Send Using Accounts macro directly into the existing Outlook New Email, Reply and Reply All and Send buttons!

Read More
Insider

Excel Copy All Worksheets in Workbook | VBA Macro #74

If you have copied a worksheet in an Excel Workbook using the Move or Copy activity, then you know that there is much to be desired during this experience. Because this activity is designed to Move or Copy multiple clicks must be made to copy the Excel Worksheet where and how you want. It is easy to forget the small checkbox confirming you want to Copy the Excel Worksheet and not Move it which is the default behavior. The Move or Copy activity gives the appearance that you can only copy one Excel Worksheet at a time but that is not the case. You can use Ctrl or Shift to make multiple selections of Excel Worksheets before accessing the Move or Copy activity. We noticed all of this at Leverage & Lean which is why we created the Excel Copy All Worksheets macro! This Excel macro will loop through all available worksheets and copy then either immediately after the current worksheet or append to the end of all available worksheets. Not only does this Excel macro provide a fast way to copy all worksheets in an Excel Workbook it also gives you the opportunity to customize the naming convention of the newly copied worksheet with some simple code updates.

Read More
Insider

Excel Quick Concatenate across Multiple Cells | VBA Macro #73

The Concatenate function in Excel is powerful in that it can create unique identifiers to help you sort and better understand your dataset. One issue with the Concatenate function is when you want to join many columns together in Excel. Setting up a Concatenate formula across 10 or more cells becomes an opportunity to pick your pain either doing a lot of typing or clicking. You can use the TextJoin function in Excel which is designed to handle concatenation across a range of cells. If you want to avoid typing a formula in Excel, then checkout Leverage & Lean’s Excel Quick Concatenate across Multiple Cells macro!

Read More

Outlook Most Recent Used Folder Move Button | VBA Macro #72

The existing Outlook Move button only displays 10 “Most Recently Used” (MRU) Folders.  We have seen your calls for an expanded list of MRU Folders when using the Move button in Outlook.  Well at Leverage & Lean we listen and let our programming do the talking!  The Outlook Most Recently Used Folders Move Button macro allows you to control how many MRU Folders you see!  This macro watches a specified Inbox and tracks when items are moved to its Subfolders.  The usage is tracked into an Excel Workbook to build your own “Most Recently Used” Move Folders registry.  This information is referenced when using this Outlook macro to display the MRU Folder options. To move items to just enter the leading number in front of the Outlook Folder name.

Read More
Insider

Excel Selection as Filter Criteria | VBA Macro #79

Filtering through large sets of data can be a challenge especially if you are looking to only apply a subset of filter selections through 100s of selections options. Good news is there is a better way with VBA when using the Leverage & Lean Excel Selection as Filter Criteria macro! This Excel macro will reference your current selection and use the contents of this range as the filter criteria.

Read More
Insider

Outlook Create Email for each Attachment | VBA Macro #78

While there is an open debate about how to run more effective meetings, we can be inefficient in providing our availability to get meetings scheduled. This is no longer the case with Leverage & Lean’s Outlook Quick Text of Calendar Availability macro! This Outlook macro will prompt you with a series of questions that will help you quickly gather the weekdays and times you are available to schedule a meeting. After these questions are answered to current Outlook email will be populated automatically with the series of weekdays (with date formatted MM/DD/YYYY), available times and duration of when you are available to meet. With this text now in the Outlook email body you can make your final adjustment removing times that shouldn’t appear. The Quick Text of Calendar Availability Outlook macro provides a standardized way of providing your meeting availability consistently each time! No longer will it be necessary to type out all this information which can be an annoying undertaking when your desire is to move on to a task that provides more value.

Read More
Insider

Outlook Quick Text of Calendar Availability | VBA Macro #77

While there is an open debate about how to run more effective meetings, we can be inefficient in providing our availability to get meetings scheduled. This is no longer the case with Leverage & Lean’s Outlook Quick Text of Calendar Availability macro! This Outlook macro will prompt you with a series of questions that will help you quickly gather the weekdays and times you are available to schedule a meeting. After these questions are answered to current Outlook email will be populated automatically with the series of weekdays (with date formatted MM/DD/YYYY), available times and duration of when you are available to meet. With this text now in the Outlook email body you can make your final adjustment removing times that shouldn’t appear. The Quick Text of Calendar Availability Outlook macro provides a standardized way of providing your meeting availability consistently each time! No longer will it be necessary to type out all this information which can be an annoying undertaking when your desire is to move on to a task that provides more value.

Read More
Insider

Excel Sort All Worksheets | VBA Macro #76

It is refreshing to see open an Excel Workbook and see all the worksheets in order.  This isn’t just refreshing but is powerful as you don’t have to waste time navigating looking for a worksheet. Being organized allows you and your colleagues to work quickly and with little effort.   This is in part of why Leverage & Lean created the Excel Sort All Worksheets macro.  This Excel macro will look at all available Excel Worksheet names and sort them in order.  Whether you are managing an Excel Workbook with names or numbers the Excel Sort All Worksheets macro will help you stay organized and allow you to focus on the work at hand.

Read More

Outlook Select Send Using Account | VBA Macro #75

If you are using multiple account in Outlook, you may find yourself forgetting who you are sending from which can be confusing for your team and worst your clients. To mistake proof the send from selection Leverage & Lean has created the Outlook Select Send Using Accounts macro! This Outlook macro will look at all your available Outlook Accounts and display them in an InputBox for you to select from. To select an Outlook Account just enter the leading number into the InputBox. This Outlook macro will then adjust your Sending Using Account to reflect the selection that you have made. While you can do this with an email open it is easy to forget to make this selection. The power of this macro is that you can create custom button to prompt you prior to creating, replying or sending an email in Outlook. You can take this a step further and embed the Outlook Select Send Using Accounts macro directly into the existing Outlook New Email, Reply and Reply All and Send buttons!

Read More
Insider

Excel Copy All Worksheets in Workbook | VBA Macro #74

If you have copied a worksheet in an Excel Workbook using the Move or Copy activity, then you know that there is much to be desired during this experience. Because this activity is designed to Move or Copy multiple clicks must be made to copy the Excel Worksheet where and how you want. It is easy to forget the small checkbox confirming you want to Copy the Excel Worksheet and not Move it which is the default behavior. The Move or Copy activity gives the appearance that you can only copy one Excel Worksheet at a time but that is not the case. You can use Ctrl or Shift to make multiple selections of Excel Worksheets before accessing the Move or Copy activity. We noticed all of this at Leverage & Lean which is why we created the Excel Copy All Worksheets macro! This Excel macro will loop through all available worksheets and copy then either immediately after the current worksheet or append to the end of all available worksheets. Not only does this Excel macro provide a fast way to copy all worksheets in an Excel Workbook it also gives you the opportunity to customize the naming convention of the newly copied worksheet with some simple code updates.

Read More
Insider

Excel Quick Concatenate across Multiple Cells | VBA Macro #73

The Concatenate function in Excel is powerful in that it can create unique identifiers to help you sort and better understand your dataset. One issue with the Concatenate function is when you want to join many columns together in Excel. Setting up a Concatenate formula across 10 or more cells becomes an opportunity to pick your pain either doing a lot of typing or clicking. You can use the TextJoin function in Excel which is designed to handle concatenation across a range of cells. If you want to avoid typing a formula in Excel, then checkout Leverage & Lean’s Excel Quick Concatenate across Multiple Cells macro!

Read More

Outlook Most Recent Used Folder Move Button | VBA Macro #72

The existing Outlook Move button only displays 10 “Most Recently Used” (MRU) Folders.  We have seen your calls for an expanded list of MRU Folders when using the Move button in Outlook.  Well at Leverage & Lean we listen and let our programming do the talking!  The Outlook Most Recently Used Folders Move Button macro allows you to control how many MRU Folders you see!  This macro watches a specified Inbox and tracks when items are moved to its Subfolders.  The usage is tracked into an Excel Workbook to build your own “Most Recently Used” Move Folders registry.  This information is referenced when using this Outlook macro to display the MRU Folder options. To move items to just enter the leading number in front of the Outlook Folder name.

Read More

Excel Selection as Filter Criteria | VBA Macro #79

Filtering through large sets of data can be a challenge especially if you are looking to only apply a subset of filter selections through 100s of selections options. Good news is there is a better way with VBA when using the Leverage & Lean Excel Selection as Filter Criteria macro! This Excel macro will reference your current selection and use the contents of this range as the filter criteria.

Read More

Outlook Create Email for each Attachment | VBA Macro #78

While there is an open debate about how to run more effective meetings, we can be inefficient in providing our availability to get meetings scheduled. This is no longer the case with Leverage & Lean’s Outlook Quick Text of Calendar Availability macro! This Outlook macro will prompt you with a series of questions that will help you quickly gather the weekdays and times you are available to schedule a meeting. After these questions are answered to current Outlook email will be populated automatically with the series of weekdays (with date formatted MM/DD/YYYY), available times and duration of when you are available to meet. With this text now in the Outlook email body you can make your final adjustment removing times that shouldn’t appear. The Quick Text of Calendar Availability Outlook macro provides a standardized way of providing your meeting availability consistently each time! No longer will it be necessary to type out all this information which can be an annoying undertaking when your desire is to move on to a task that provides more value.

Read More

Outlook Quick Text of Calendar Availability | VBA Macro #77

While there is an open debate about how to run more effective meetings, we can be inefficient in providing our availability to get meetings scheduled. This is no longer the case with Leverage & Lean’s Outlook Quick Text of Calendar Availability macro! This Outlook macro will prompt you with a series of questions that will help you quickly gather the weekdays and times you are available to schedule a meeting. After these questions are answered to current Outlook email will be populated automatically with the series of weekdays (with date formatted MM/DD/YYYY), available times and duration of when you are available to meet. With this text now in the Outlook email body you can make your final adjustment removing times that shouldn’t appear. The Quick Text of Calendar Availability Outlook macro provides a standardized way of providing your meeting availability consistently each time! No longer will it be necessary to type out all this information which can be an annoying undertaking when your desire is to move on to a task that provides more value.

Read More

Excel Sort All Worksheets | VBA Macro #76

It is refreshing to see open an Excel Workbook and see all the worksheets in order.  This isn’t just refreshing but is powerful as you don’t have to waste time navigating looking for a worksheet. Being organized allows you and your colleagues to work quickly and with little effort.   This is in part of why Leverage & Lean created the Excel Sort All Worksheets macro.  This Excel macro will look at all available Excel Worksheet names and sort them in order.  Whether you are managing an Excel Workbook with names or numbers the Excel Sort All Worksheets macro will help you stay organized and allow you to focus on the work at hand.

Read More

Outlook Select Send Using Account | VBA Macro #75

If you are using multiple account in Outlook, you may find yourself forgetting who you are sending from which can be confusing for your team and worst your clients. To mistake proof the send from selection Leverage & Lean has created the Outlook Select Send Using Accounts macro! This Outlook macro will look at all your available Outlook Accounts and display them in an InputBox for you to select from. To select an Outlook Account just enter the leading number into the InputBox. This Outlook macro will then adjust your Sending Using Account to reflect the selection that you have made. While you can do this with an email open it is easy to forget to make this selection. The power of this macro is that you can create custom button to prompt you prior to creating, replying or sending an email in Outlook. You can take this a step further and embed the Outlook Select Send Using Accounts macro directly into the existing Outlook New Email, Reply and Reply All and Send buttons!

Read More

Excel Copy All Worksheets in Workbook | VBA Macro #74

If you have copied a worksheet in an Excel Workbook using the Move or Copy activity, then you know that there is much to be desired during this experience. Because this activity is designed to Move or Copy multiple clicks must be made to copy the Excel Worksheet where and how you want. It is easy to forget the small checkbox confirming you want to Copy the Excel Worksheet and not Move it which is the default behavior. The Move or Copy activity gives the appearance that you can only copy one Excel Worksheet at a time but that is not the case. You can use Ctrl or Shift to make multiple selections of Excel Worksheets before accessing the Move or Copy activity. We noticed all of this at Leverage & Lean which is why we created the Excel Copy All Worksheets macro! This Excel macro will loop through all available worksheets and copy then either immediately after the current worksheet or append to the end of all available worksheets. Not only does this Excel macro provide a fast way to copy all worksheets in an Excel Workbook it also gives you the opportunity to customize the naming convention of the newly copied worksheet with some simple code updates.

Read More

First time using VBA?

First time using VBA?

Get started with these three easy steps!

Contact Us

Looking to improve your computer processes?
Leverage & Lean is here to help!

Powered By MemberPress WooCommerce Plus Integration