This utility has been renamed as Track Snap, which can take a snapshot of the current workbook with one click at any time, and click on the snapshot item will restore the workbook to the snapshot.Please note that this utility will only keep the snapshot available before closing the workbook, if the workbook has been closed, all snapshots of the workbook will be cleaned. Yes, you can create a button to run a specific macro either in QAT of Ribbon or working area in Microsoft Excel.But Kutools for Excel’s Batch Insert Check Boxes utility and Batch Insert Option Buttons utility can help Excel users quickly insert multiple checkboxes or option buttons into all selected cells.
Insert macro button in working area of current workbook Insert macro button in the Quick Access Toolbar on Ribbon Easily remove all macros from multiple closed workbooks Normally we can only insert one checkbox or option button in a cell at a time with tedious steps in Excel.This utility has embodied 3 types of working area settings in your Excel. To minimize the ribbon, hide the status bar, the formula bar and the ribbon.It's quite handy when you need to quickly minimize or hide the status bar and the formula bar for a large working area. It is inevitable that lines or columns will be misread when we check for formulas or data in a worksheet with a large number of rows and columns.More precisely, I explain in detail how you can save Excel files as PDF using VBA, and provide 10 examples of VBA code that you can start using immediately.In fact, in this blog post, I go much further than simply showing you how to simply convert Excel files to PDF.Wouldn’t it be great to be able to link the axis scale parameters to values or, even better, formulas in the worksheet? If you want a ready-to-use solution, try Tushar Mehta’s Auto Chart Manager add-in, available as a free download at You can write the entire procedure yourself, but it’s easier and more reliable to let the VB Editor start it for you.