Category: Excel VBA

Excel Hyperlinks Run Command http://blog.contextures.com/ 1

Excel Hyperlinks Run Command Files

You can use Excel hyperlinks to navigate through a workbook, go to web pages, open other Excel files, and even open PDF files. However, if you try to use an Excel hyperlink to run...

Pop Up Selector Tool Demo 8

Excel Pop Up Selector Tool With Slicer

Slicers make it easy to select from a list of items, but they take up valuable space on your worksheet. To get the benefits of a Slicer, without the real estate cost, AlexJ made...

Freeze All Worksheets Macro 2

Excel Freeze All Worksheets Macro

If you’re working with a large worksheet in Excel, it usually helps if you freeze the cells at the top and/or the left side of the sheet. That way, your headings are always visible,...

list of Excel sheets 3

Popup List of Excel Sheets

If you’re working in an Excel file with lots of worksheets, it can take a while to scroll to the ones that you need. Sometimes you can’t even remember where the sheets are, and...

Form Control Button Quirks 0

Excel Form Control Button Quirks

If you’re building an Excel workbook for other people to use, you can add form control buttons, so it’s easy for them to run macros. One of my sample files has Navigation Buttons on...

prevent grouped dates in Excel 3

How to Prevent Grouped Dates in Excel

As a teenager, group dates can be fun. If you have strict parents, that might be the only kind of dates they allow! But, in your Excel worksheets, it can be annoying when dates...

hide sheets based on tab color 1

Hide Sheets Based on Tab Color

Last month, I showed you my code that hides worksheets, based on the text in their names. Someone asked we could hide sheets based on tab color instead, so that’s how today’s example works....

Show Specific Sheets in Excel With Drop Down List 4

Show Specific Sheets in Excel

In a workbook with lots of worksheets, you can have a hard time finding the sheets that you need, to do a specific task. Instead of scrolling through all the sheet tabs, or using...

Popup List on Click or Double-Click http://blog.contextures.com/ 0

Change Excel VBA Code to Improve Speed

In some of my files, macros run automatically when you select a cell on the worksheet. For example, if you’ve bought a copy of my Data Validation Multi-Select Premium (DVMSP) kit, it shows a...

Show Message in Status Bar http://blog.contextures.com/ 11

Show Message In Excel Status Bar

If a macro takes a long time to run, it can be frustrating to wait for it to finish. Usually the screen updating is turned off when a macro runs, so it’s hard to...