Excel resources
Excel Macros
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 4 of 4 · 33 articles
How to find named ranges in Excel by highlighting them using VBA
Highlighting them on your worksheets can help you identify their properties easily. Let us show you how to find named ranges in Excel.
How to lock a cell in Excel formula using VBA
In this article, we're going to show you how to lock a cell in Excel formula using VBA and prevent your users from changing formulas or data.
How to un-protect a protected worksheet and vice versa - the VBA method
In this article, we're going to show you how to 'un-protect' protected worksheets and how to protect un-protected worksheets using VBA.
How to alphabetize Excel tabs using VBA
In this article, we're going to show you how to alphabetize Excel worksheets in ascending or descending alphabetical order using VBA.
How to unhide sheets in Excel with VBA
Learn how to unhide sheets in Excel with VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
Improving VBA Macro Performance
In many cases, some Excel features can slow down the execution of your application unnecessarily. In this article, we’re going to show you different methods for improving VBA macro performance by manipulating these settings.