Quickly add your favourite macros to a custom tab on the Excel Ribbon. Then, use those macros in other Excel files, with just a couple of clicks.
Continue reading “Get This Custom Tab for Excel Macros – Demo”
Category: Excel VBA
Excel File Auto Backup When Workbook Saved
Do you hit the Save button frequently, while you work in Excel? And do you make backup copies of your Excel files, especially before making major changes? Or, do you only think about saving, right after Excel crashes?
Continue reading “Excel File Auto Backup When Workbook Saved”
Video: Dependent Combo Boxes – Excel Data Entry
Make it easy to enter valid data in an Excel workbook. Choose “Fastener” in one combo box drop down. The next combo box shows a list of fastener parts, with part ID and part name.
This video shows how to use this simple data entry tool, and you’ll get a peek behind the scenes, on how it works.
Continue reading “Video: Dependent Combo Boxes – Excel Data Entry”
Excel Footer Font Fix and Custom Footer Macro
When you’re printing financial reports in Excel, do you set them up to print one page wide? That feature saves paper, but it can make the header and footer text too small to read, especially if it’s in a small font size already. Here’s how you can avoid that problem. And there’s a macro to create a custom worksheet footer too!
Continue reading “Excel Footer Font Fix and Custom Footer Macro”
Excel Macro to Increase Amount in Multiple Cells
Every morning, I use Excel to keep track of the projects I’m working on, and organize my tasks for the day. Of course, things don’t always go as planned, but it helps to know where I’m headed!
Continue reading “Excel Macro to Increase Amount in Multiple Cells”
Excel Threaded Comments and Replies List Details-Macro
Keep track of Excel worksheet discussions, with a detailed list of threaded comments and replies. Just click a button, to run a macro, that makes the list for you. And I’ve fixed the macro!
Continue reading “Excel Threaded Comments and Replies List Details-Macro”
Excel Macros Create Monthly Workbooks Entire Year
Happy December! We’ve almost made it to the end of this year, and you’re probably getting reading for next year’s tasks and projects. If you need to set up monthly workbooks for next year, or automatically add sheets to existing workbooks, these Excel macros can help you!
Continue reading “Excel Macros Create Monthly Workbooks Entire Year”
Search Transaction Records with Excel UserForm
There’s an Excel UserForm that you can download from my Contextures site, and use it to search, view, and edit records in an Excel table. The two short videos below show how the UserForm works, and how you can put flexible criteria in the search boxes.
And remember – it’s almost Spreadsheet Day – we’ll celebrate on Monday, October 17th!
Continue reading “Search Transaction Records with Excel UserForm”
Excel Workbook for Golf Tee Off Times Update
Whether you’re scheduling players for a golf tournament, or assigning employees for daily shifts, Excel can make the job easier. There’s a Golf Tee Off Times example on my site, and you could adapt it for building other types of schedules. This week, I uploaded a second version of the file – it gives you more flexibility in assigning people to specific times.
Continue reading “Excel Workbook for Golf Tee Off Times Update”
PowerPoint Slides From Excel List
If you have a list of names or topics in Excel, here’s how you can quickly create PowerPoint slides from that list. Unlike most of my macros, these run in PowerPoint, to pull the data from Excel. That was easier than writing Excel macros to make things happen in PowerPoint!