Ron's Excel Tips
Ron de Bruin (last updated 23-July-2011)
https://www.rondebruin.nl/
Published articles
My articles on the Microsoft Office Developer Center (MSDN)
Creating Popup Menus in All Versions of Excel
Customizing Context Menus in All Versions of Microsoft Excel
Working with the Compatibility Checker in Excel 2007 and Excel 2010
Using VBA in Excel to Send Workbooks and Ranges through E-Mail with Outlook (Part 1 of 2)
Using VBA in Excel to Send Workbooks and Ranges through E-Mail with Outlook (Part 2 of 2)
Creating and Sending PDF Files from Excel 2007 and Excel 2010
Working with Excel Workbooks and Worksheets in E-Mail
Display and Hide Tabs, Groups, and Controls on the Microsoft Office Ribbon (Part 1 of 2)
Display and Hide Tabs, Groups, and Controls on the Microsoft Office Ribbon (Part 2 of 2)
Creating Custom Ribbon Galleries in Excel 2007
Working with Lists and Tables: VBA Samples (Part 1 of 2)
Working with Lists and Tables: VBA Samples (Part 2 of 2)
Filtering by the Active Cell's Value, Font Color, or Fill Color in Excel 2007
Consolidating Data from Multiple Worksheets into a Summary Worksheet in Excel
Merging Data from Multiple Workbooks into a Summary Workbook in Excel
Implementing Week-Numbering Systems and Date/Time Representations in Excel
Different Ways to Take Advantage of the E-mail Features of Excel (Excel 97-2003)
Office Visual How To
Merging Data from Multiple Workbooks into a Summary Workbook in Excel New
My articles on Microsoft Office Online
Aanpassen van het Lint in Excel 2007 (Dutch)
Weeknummers berekenen in Excel (Dutch)
My Excel tips
VBA code in Mac Excel 2011 and Windows Excel NEW
Excel Add-ins and code for Mailing from Excel
Excel Add-ins page
Example Code for sending mail from Excel Tip
Mail code examples for Lotus Notes
Pages only for Excel 2007-2010
Create and Mail PDF files with Excel 2007/2010
Use VBA SaveAs in Excel 2007-2010
Compatibility Checker in Excel 2007-2010
Sheet Direction in Excel 2007-2010
Filtering by the Active Cell's Value, Font Color or Fill Color in Excel 2007-2010
Disable Excel 2003 Menu Accelerators keys in Excel 2007-2010
Table Tools Add-in for Excel 2007-2010
VBA code examples for a List or Table in Excel 2003-2010
Help: Different Excel file formats and Excel versions
Where can I find the menu commands in Excel 2007
Macros are disabled when you open password protected workbooks in 2007
Shapes and VBA code in Excel 2007
Copy sheet security dialog in Excel 2007
Reverse compatibility problem of the old ATP functions in Excel 2007
Excel 2007-2010 Ribbon and QAT pages
Change the Ribbon in Excel 2007 or Excel 2010
Avoid losing the state of the global IRibbonUI ribbon object New
Change built-in groups in the Ribbon
Add missing built-in commands to the QAT or Ribbon
Load different RibbonX when opening file in Excel 2007 or 2010
Customize Contextual tabs in Excel 2007 and Excel 2010
How do I change Backstage(File) view in Excel 2010
Menu for favorite macros in Excel 2007-2010 (for all workbooks)
Menu for favorite macros in Excel 2007-2010 (for one workbook)
Add buttons to the QAT and customize the images of the buttons
Images on Custom Ribbon controls Updated
Menu in the Ribbon with different languages
Galleries in the Ribbon
Hide or Display Ribbon Tab/Group/Control with getVisible
Enable or Disable custom Ribbon buttons in Excel 2007-2010 New
Where is my button that I add to the QAT of my workbook
Dealing with Ribbons and Menus - Avoiding Two Versions
Customizing Context Menus in Microsoft Excel
Context and Popup menus and Application.Run
Customizing Context Menus in Microsoft Excel
Creating a PopUp Menu that is working in every Excel version
How do I use Application.Run in Excel
Copy/Paste/Merge examples
Copy to a database sheet on the next empty row
Merge cells from all or some worksheets into one Master worksheet
Create a summary worksheet from all worksheets (formulas with VBA)
Create a link to or Sum a cell in all worksheets (worksheet functions)
Merge data from all workbooks in a folder (1)
Merge data from all workbooks in a folder (2)
Merge data from all workbooks in a folder: Add-in
Create a summary worksheet from different workbooks (formulas with VBA)
Merge data from all workbooks in a folder to a txt file
Copy every TXT or CSV file in a new worksheet of a newly created workbook
Merge all CSV or TXT files in a folder
Copy a range from closed workbooks (ADO)
Copy a range from closed workbook (Local, Network and on the internet)
Copy data from an Access database into Excel with ADO
Change cells or range in all workbooks in a folder
Copy records with the same value in a column to a new sheet or workbook
VBA code examples for a List or Table in Excel 2003-2010
Create a workbook from every worksheet in your workbook
Create separate sheet for each horizontal PageBreak
Copy, Move and Delete files and folders
How do I create/use a sheet template
Delete/Hide/Disable examples
Delete row if a specific value exist
Delete or Hide Objects/Controls on a worksheet
Disable command bars and controls in Excel 97-2003
SpecialCells limit problem
Disable key or key combination or run a macro if you use it
Zip (compress) ActiveWorkbook, Folder, File or Files with VBA code
7-zip : Zip Activeworkbook, Folder, File or Files(VBA)
7-zip : Unzip a zip file (VBA)
Zip file or files with the default Windows zip program (VBA)
Unzip zip file or files with the default Windows zip program(VBA)
WinZip : Zip Activeworkbook, Folder, File or Files (VBA)
WinZip : Unzip a zip file(VBA)
Weeknumber/Dates
Use the Calendar control to fill in dates
Week numbers
ISO Date Representatation and Week Numbering
Help information
Read and post in Forums with the Community Forums NNTP Bridge
Help Context IDs for Excel 2000, 2002, 2003 and 2007
Where do I paste the code that I want to use in my workbook
How do I create a PERSONAL.XLS(B) or Add-in
Other pages
International Excel Issues
Print tips for Excel
Test if Folder, File or Sheet exists or File is open
Find last row, column or last cell
Change formulas to values
Find value in Range, Sheet or Sheets with VBA
Cleaning "Dirty" Data
Lotus Transition Formula Evaluation Errors
Analysis ToolPak Translator 7.0
CAclubindia
