This macro inserts Wingdings Check Mark symbol with in the specified range. This also demonstrate the trick to change values within a range by just double click on the cell.
Custom Function to find closest match in excel. This works on unsorted range and is capable of finding greater than equal to or less than equal to value.
This fie has UDF to Extract Numbers from Text. Numbers can be anywhere within the text string. Only rule is that it will extract number from start till you encounter non numeric characters
Excel Macro to open a workbook after validating that workbook in already not open. This gives you file open dialog box if the file is not available in the directory of your current file having this macro.
This is unlocked version of Harware locking for workbook. This help you understand how to place this code into your project. This is unlocked version and will open on your machine.
This demonstraits the VBA capability to lock a workbook to particular machine. This is locked file and you will not be able to open this as it will fail in harware security test on your machine
Excel VBA Custom Function that can convert any number to words. This function will not handle faractions and all fractions will be rounded off before converting them to words. There are no prefix of sufix in this.
Excel Macro to maintain user activity log on a log sheet within the workbook. Macro has capability to create log sheet if it is not avaiable. It further has capability to manage the log data after certain number of records the old entries are deleted and new entries keep on adding.
