How to delete all comments in Excel using VBA

How to delete all comments in Excel using VBA

Excel, just like other Office products, supports comments. Although comments are helpful to add tips or other details into your spreadsheets, deleting them may become time consuming while trying to find and select all of them. In this article, we’re going to...
How to prevent Save As with VBA

How to prevent Save As with VBA

This article shows you How to prevent Save As with VBA. You can control your workbook’s events like opening, closing or saving by VBA. Events for Excel’s native objects are built in and ready to use. To prevent Save As event, the address is Workbook...