Excel Macros

SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
ą

View Download
File for Format Numbers blog post  22k v. 1 Oct 22, 2017, 7:50 AM Yogesh Gupta
ą

View Download
File for Format Numbers blog post  23k v. 1 Oct 22, 2017, 7:48 AM Yogesh Gupta
ą

View Download
File for Add spin buttons Active X blog post  114k v. 1 Oct 22, 2017, 6:59 AM Yogesh Gupta
Ĉ
View Download
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.  48k v. 1 Oct 31, 2009, 12:11 AM Yogesh Gupta
ċ

Download
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.  250k v. 3 Jan 16, 2010, 7:18 PM Yogesh Gupta
ą

View Download
File for Deploy Macros found elsewhere blog post   42k v. 1 Oct 22, 2017, 8:06 AM Yogesh Gupta
ą

View Download
File for Deploy Macros found elsewhere blog post   47k v. 1 Oct 22, 2017, 8:03 AM Yogesh Gupta
ą

View Download
File for Deploy Macros found elsewhere blog post  67k v. 1 Oct 22, 2017, 7:57 AM Yogesh Gupta
ą

View Download
File for Deploy Macros found elsewhere blog post   38k v. 1 Oct 22, 2017, 7:59 AM Yogesh Gupta
ą

View Download
File for Deploy Macros found elsewhere blog post   31k v. 1 Oct 22, 2017, 8:01 AM Yogesh Gupta
ą

View Download
File for Blog Post Create Range Names  31k v. 1 Oct 22, 2017, 6:49 AM Yogesh Gupta
ą

View Download
GIF file for create range names blog post  129k v. 1 Oct 22, 2017, 6:50 AM Yogesh Gupta
ą

View Download
File for Excel Date picker blog post  99k v. 1 Oct 22, 2017, 8:17 AM Yogesh Gupta
Ĉ
View Download
Excel file with Date Picker. File has VBA code that can be viewed and modified as per need.  104k v. 1 Dec 31, 2009, 11:35 PM Yogesh Gupta
Ĉ
View Download
Excel Macro to Disable Cut Copy and Paste function in a workbook  39k v. 1 Oct 31, 2009, 12:01 AM Yogesh Gupta
Ĉ
View Download
Macros in this file will disable cut and will allow copy from another workbook  30k v. 1 Jul 15, 2010, 10:49 AM Yogesh Gupta
Ĉ
View Download
This file has VBA code that will save active sheet as temp file and send it through outlook to email id specifiled by you.  35k v. 1 Jul 24, 2010, 10:45 AM Yogesh Gupta
Ĉ
View Download
This UDF can extract email addressed from text String. Includes a UDF contributed by Rick Rothstein (MVP - Excel).   38k v. 3 Nov 19, 2009, 1:06 AM Yogesh Gupta
ą

View Download
File for PMT Function blog post  19k v. 1 Oct 22, 2017, 7:12 AM Yogesh Gupta
ą

View Download
File for PMT Function blog post  181k v. 1 Oct 22, 2017, 7:09 AM Yogesh Gupta
Ĉ
View Download
Excel Macro to Declare Validity date of a workbook, File gets expired after certain period and users can not use that file after that date  32k v. 1 Oct 31, 2009, 12:04 AM Yogesh Gupta
ċ

Download
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  43k v. 1 Dec 4, 2009, 8:25 PM Yogesh Gupta
ċ

Download
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.  50k v. 1 Oct 31, 2009, 12:06 AM Yogesh Gupta
Ĉ
View Download
This macro forces users to enable macros on their machine. In case they do not enable macros, they are not able to use the workbook  35k v. 1 Oct 31, 2009, 12:08 AM Yogesh Gupta
Ĉ
View Download
This has UDF to find the last row of data. This also demonstraits how to use this UDF for your data processing requirements  55k v. 1 Oct 31, 2009, 12:19 AM Yogesh Gupta
Ĉ
View Download
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.   40k v. 1 Nov 1, 2009, 2:23 AM Yogesh Gupta
Ĉ
View Download
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  32k v. 1 Nov 1, 2009, 2:21 AM Yogesh Gupta
Ĉ
View Download
This file has macro which hide contents in Cell A1 while printing   44k v. 3 Nov 13, 2009, 7:15 AM Yogesh Gupta
ą

View Download
File for Deploy Macros found elsewhere blog post    85k v. 1 Oct 22, 2017, 8:07 AM Yogesh Gupta
ċ

Download
Excel Macro to Format numbers in Indian style comma separation  41k v. 1 Oct 31, 2009, 9:07 AM Yogesh Gupta
Ĉ
View Download
This UDF connverts Numbers to Words in Indian style. The values are converted into words as Rs in Lacs, Crores and Arabs.  45k v. 1 Nov 4, 2009, 8:50 PM Yogesh Gupta
ą

View Download
File for Pivot Tables blog post  8k v. 1 Oct 22, 2017, 7:53 AM Yogesh Gupta
Ĉ
View Download
Excel Macro to Find and Remove Duplicates within a Range  44k v. 1 Oct 30, 2009, 11:58 PM Yogesh Gupta
Ĉ
View Download
Excel Macro to Find and Remove Duplicates  60k v. 1 Oct 30, 2009, 11:57 PM Yogesh Gupta
ą

View Download
File for Show Developer Tab blog post  29k v. 1 Oct 22, 2017, 7:04 AM Yogesh Gupta
ą

View Download
File for Sorting dates on date of birth blog post  49k v. 1 Oct 22, 2017, 8:11 AM Yogesh Gupta
Ĉ
View Download
This is user defined function to conver the numbers to currency in text as you write on checks or Invoices etc  43k v. 1 Oct 21, 2009, 7:24 AM Yogesh Gupta
ą

View Download
Spell Currency GIF files  32k v. 1 Oct 22, 2017, 6:32 AM Yogesh Gupta
ċ

Download
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.  75k v. 1 Jan 14, 2010, 11:53 PM Yogesh Gupta
ą

View Download
File for Add spin buttons Active X blog post  59k v. 1 Oct 22, 2017, 6:56 AM Yogesh Gupta
ą

View Download
File for Sub Total blog post  22k v. 1 Oct 22, 2017, 7:20 AM Yogesh Gupta
ą

View Download
File for Sum top 5 in unsorted range blog post  2k v. 1 Oct 22, 2017, 8:13 AM Yogesh Gupta
Ĉ
View Download
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.  54k v. 1 Oct 31, 2009, 12:24 AM Yogesh Gupta
Comments