Quick-Freeze All Workbook Values in Excel
VBA/Macro Course: https://www.teachexcel.com/vba-course...
How to freeze the currently visible values in the entire workbook with the click of a button.
This allows you to quickly save the current state of the workbook and prevent the cells from changing. This includes freezing all formulas and linked cells.
Note: This method does remove all formulas from all cells and it will then put only the currently visible values into those cells. This can cause you to lose functionality in your workbook - as a result, make sure to run this code on a copy of the original workbook so that you don't lose any important data.
To build even more powerful VBA projects or further customize this one, checkout my full VBA Course: https://www.teachexcel.com/vba-course...
#msexcel #vba #tutorial
![Excel Workbook Reset with a Single Button Click [Easy Version]](https://images.videosashka.com/watch/5CZMxcCFxIg)
