Excel Tips and Tricks

Printing values instead of the formulas themselves can help protect your IP or prevent users from changing them. In this article, we're going to show you how to have Excel convert formula to value using VBA.   How to have Excel convert formula to...

Users entering data into the wrong cells or changing existing formulas can make data collection a tedious process. However, you can prevent users from going outside the intended boundaries by disabling certain sections of your workbook. In this article,...

The common ways of locking or hiding tabs in a workbook can be easy to reverse for many users. Using VBA code to do this is considered a better way to do this, if you are familiar with macros. In this article, we're going to show you how to 'un-protect' protected...

Keeping your data and calculations on separate tabs is easy for an organized structure, but too many tabs in a workbook can become overwhelming quickly. In this article, we're going to show you how to alphabetize Excel worksheets  in ascending or...

You might want to hide or unhide certain sheets in a workbook for security reasons and there are several ways you can do this. In this article, we're going to show you how to unhide sheets in Excel with VBA.   How to unhide sheets in Excel Worksheets...