A macro-enabled excel file can save automatically when changing any cell value. See the below given VBA code for autosave : 1. Right-click the sheet tab that you want to autosave the workbook after entering new data, and then choose View Code from the context menu, in the opened Microsoft Visual Basic for Applications window, copy and paste the […]
Suicide of An Excel File!
This is not a story, an amazing VBA code to protect your highly confidential excel file from theft/miss use. If you have developed a workbook which you want to self-expire by a certain date, such as a demonstration model or containing information or usefulness that will be outdated, you can program a workbook to delete […]
