You will now see a menu item called "Suresh Utilities" in your main Excel toolbar (usually near the Help menu).
SureshAddin.xla is a legacy Microsoft Excel add-in primarily designed to simplify financial reporting for Indian users by converting numerical figures into words according to the Indian numbering system. Key Functions
The add-in introduces custom formulas that handle currency formatting and text conversion:
=INR(Cell_Reference): Converts a number into a currency-formatted string (e.g., adding commas in the lakhs/crore format). However, this result is typically in text format.
=REVINR(Cell_Reference): Reverts the text-formatted INR result back into a standard number format so it can be used for further mathematical calculations.
=RSWORDS(Cell_Reference): Translates a number into written words (e.g., "Five Thousand Only"), which is essential for professional invoicing and bank checks. Installation & Setup Sureshaddin.xla
As an .xla file (a legacy Excel Add-In format), it requires manual activation:
Download and Save: Store the SureshAddin.xla file in a permanent folder on your computer.
Enable Developer Tab: If not visible, enable the Developer tab in Excel.
Manage Add-ins: Go to File > Options > Add-ins, select Excel Add-ins from the 'Manage' dropdown, and click Go.
Browse: Use the Browse button to locate the saved .xla file, then click OK to activate it. Compatibility You will now see a menu item called
While built for older versions like Excel 2007, these files often remain compatible with modern 64-bit Excel versions, though newer .xlam files are now the standard. If the functions stop working after a crash, you may need to re-enable them via the Disabled Items menu in Excel Options. How to Re-enable an Add-in that is Disabled or Missing
Unlike a normal Excel workbook (.xlsx), an add-in (.xla or .xlam) is designed to add functionality to Excel itself. When you open Sureshaddin.xla, you won’t see a normal spreadsheet. Instead, it loads custom functions, macros, and buttons into the background of Excel.
Typical uses for a custom add-in like this include:
' Code for ThisWorkbook or a Module to handle menus
Const MenuName As String = "Suresh Utilities"
Sub Auto_Open()
' Creates the menu item when Excel starts
Call CreateMenu
End Sub
Sub Auto_Close()
' Removes the menu item when Excel closes
Call DeleteMenu
End Sub
Sub CreateMenu()
Dim HelpMenu As CommandBarControl
Dim NewMenu As CommandBarPopup
Dim MenuItem As CommandBarControl
Dim SubMenuItem As CommandBarButton
' Delete the menu if it already exists
Call DeleteMenu
' Find the Help Menu position to insert before it
Set HelpMenu = CommandBars(1).FindControl(ID:=30010) ' ID for Help
' Create the main menu popup
Set NewMenu = CommandBars(1).Controls.Add(Type:=msoControlPopup, Before:=HelpMenu.Index, Temporary:=True)
NewMenu.Caption = MenuName
' --- ADD MENU ITEMS ---
' 1. Toggle Gridlines
Set MenuItem = NewMenu.Controls.Add(Type:=msoControlButton)
With MenuItem
.Caption = "Toggle Gridlines"
.OnAction = "ToggleGridlines"
.FaceId = 364 ' Icon for grid
End With
' 2. Sheet Protection Tools
Set MenuItem = NewMenu.Controls.Add(Type:=msoControlPopup)
MenuItem.Caption = "Protection Tools"
' Sub-item: Protect All
Set SubMenuItem = MenuItem.Controls.Add(Type:=msoControlButton)
SubMenuItem.Caption = "Protect All Sheets"
SubMenuItem.OnAction = "ProtectAllSheets"
' Sub-item: Unprotect All
Set SubMenuItem = MenuItem.Controls.Add(Type:=msoControlButton)
SubMenuItem.Caption = "Unprotect All Sheets"
SubMenuItem.OnAction = "UnprotectAllSheets"
' 3. Case Changer
Set MenuItem = NewMenu.Controls.Add(Type:=msoControlButton)
With MenuItem
.Caption = "Change Case to UPPERCASE"
.OnAction = "ChangeCaseUpper"
End With
' 4. Insert Row (A common utility)
Set MenuItem = NewMenu.Controls.Add(Type:=msoControlButton)
With MenuItem
.Caption = "Insert Row After Selection"
.OnAction = "InsertRowAtSelection"
End With
End Sub
Sub DeleteMenu()
' Safely remove the menu
On Error Resume Next
CommandBars(1).Controls(MenuName).Delete
On Error GoTo 0
End Sub
' Public function callable from a worksheet
Public Function SafeDivide(numerator As Double, denominator As Double) As Variant
On Error GoTo ErrHandler
If denominator = 0 Then
SafeDivide = CVErr(xlErrDiv0)
Else
SafeDivide = numerator / denominator
End If
Exit Function
ErrHandler:
SafeDivide = CVErr(xlErrValue)
End Function
If you find that Sureshaddin.xla contains useful logic but looks ancient (think Excel 2003 era), consider upgrading it:
Sureshaddin.xla is a time capsule—a piece of one person’s ingenuity to make Excel work better. Whether it’s a forgotten relic or a critical business tool depends entirely on your context. Treat it with respect, audit its code, and either embrace it or gracefully retire it. If no Developer tab: File → Options →
Have you ever found a mysterious .xla file at work? Share your story in the comments below!
It looks like you're referencing a file named Sureshaddin.xla — most likely an Excel Add-In (.xla extension, the legacy format for Excel add-ins before .xlam).
Here’s what you should know:
You will now see a menu item called "Suresh Utilities" in your main Excel toolbar (usually near the Help menu).
SureshAddin.xla is a legacy Microsoft Excel add-in primarily designed to simplify financial reporting for Indian users by converting numerical figures into words according to the Indian numbering system. Key Functions
The add-in introduces custom formulas that handle currency formatting and text conversion:
=INR(Cell_Reference): Converts a number into a currency-formatted string (e.g., adding commas in the lakhs/crore format). However, this result is typically in text format.
=REVINR(Cell_Reference): Reverts the text-formatted INR result back into a standard number format so it can be used for further mathematical calculations.
=RSWORDS(Cell_Reference): Translates a number into written words (e.g., "Five Thousand Only"), which is essential for professional invoicing and bank checks. Installation & Setup
As an .xla file (a legacy Excel Add-In format), it requires manual activation:
Download and Save: Store the SureshAddin.xla file in a permanent folder on your computer.
Enable Developer Tab: If not visible, enable the Developer tab in Excel.
Manage Add-ins: Go to File > Options > Add-ins, select Excel Add-ins from the 'Manage' dropdown, and click Go.
Browse: Use the Browse button to locate the saved .xla file, then click OK to activate it. Compatibility
While built for older versions like Excel 2007, these files often remain compatible with modern 64-bit Excel versions, though newer .xlam files are now the standard. If the functions stop working after a crash, you may need to re-enable them via the Disabled Items menu in Excel Options. How to Re-enable an Add-in that is Disabled or Missing
Unlike a normal Excel workbook (.xlsx), an add-in (.xla or .xlam) is designed to add functionality to Excel itself. When you open Sureshaddin.xla, you won’t see a normal spreadsheet. Instead, it loads custom functions, macros, and buttons into the background of Excel.
Typical uses for a custom add-in like this include:
' Code for ThisWorkbook or a Module to handle menus
Const MenuName As String = "Suresh Utilities"
Sub Auto_Open()
' Creates the menu item when Excel starts
Call CreateMenu
End Sub
Sub Auto_Close()
' Removes the menu item when Excel closes
Call DeleteMenu
End Sub
Sub CreateMenu()
Dim HelpMenu As CommandBarControl
Dim NewMenu As CommandBarPopup
Dim MenuItem As CommandBarControl
Dim SubMenuItem As CommandBarButton
' Delete the menu if it already exists
Call DeleteMenu
' Find the Help Menu position to insert before it
Set HelpMenu = CommandBars(1).FindControl(ID:=30010) ' ID for Help
' Create the main menu popup
Set NewMenu = CommandBars(1).Controls.Add(Type:=msoControlPopup, Before:=HelpMenu.Index, Temporary:=True)
NewMenu.Caption = MenuName
' --- ADD MENU ITEMS ---
' 1. Toggle Gridlines
Set MenuItem = NewMenu.Controls.Add(Type:=msoControlButton)
With MenuItem
.Caption = "Toggle Gridlines"
.OnAction = "ToggleGridlines"
.FaceId = 364 ' Icon for grid
End With
' 2. Sheet Protection Tools
Set MenuItem = NewMenu.Controls.Add(Type:=msoControlPopup)
MenuItem.Caption = "Protection Tools"
' Sub-item: Protect All
Set SubMenuItem = MenuItem.Controls.Add(Type:=msoControlButton)
SubMenuItem.Caption = "Protect All Sheets"
SubMenuItem.OnAction = "ProtectAllSheets"
' Sub-item: Unprotect All
Set SubMenuItem = MenuItem.Controls.Add(Type:=msoControlButton)
SubMenuItem.Caption = "Unprotect All Sheets"
SubMenuItem.OnAction = "UnprotectAllSheets"
' 3. Case Changer
Set MenuItem = NewMenu.Controls.Add(Type:=msoControlButton)
With MenuItem
.Caption = "Change Case to UPPERCASE"
.OnAction = "ChangeCaseUpper"
End With
' 4. Insert Row (A common utility)
Set MenuItem = NewMenu.Controls.Add(Type:=msoControlButton)
With MenuItem
.Caption = "Insert Row After Selection"
.OnAction = "InsertRowAtSelection"
End With
End Sub
Sub DeleteMenu()
' Safely remove the menu
On Error Resume Next
CommandBars(1).Controls(MenuName).Delete
On Error GoTo 0
End Sub
' Public function callable from a worksheet
Public Function SafeDivide(numerator As Double, denominator As Double) As Variant
On Error GoTo ErrHandler
If denominator = 0 Then
SafeDivide = CVErr(xlErrDiv0)
Else
SafeDivide = numerator / denominator
End If
Exit Function
ErrHandler:
SafeDivide = CVErr(xlErrValue)
End Function
If you find that Sureshaddin.xla contains useful logic but looks ancient (think Excel 2003 era), consider upgrading it:
Sureshaddin.xla is a time capsule—a piece of one person’s ingenuity to make Excel work better. Whether it’s a forgotten relic or a critical business tool depends entirely on your context. Treat it with respect, audit its code, and either embrace it or gracefully retire it.
Have you ever found a mysterious .xla file at work? Share your story in the comments below!
It looks like you're referencing a file named Sureshaddin.xla — most likely an Excel Add-In (.xla extension, the legacy format for Excel add-ins before .xlam).
Here’s what you should know: