×

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

  • If no Developer tab: File → Options → Customize Ribbon → enable Developer.
  • Search VBA for suspicious code patterns: Shell, CreateObject, URLDownloadToFile, Base64, Execute, WScript, FileSystemObject, API calls, Windows registry edits.
  • If you prefer no Excel: open file with a ZIP/7-zip tool (may not show VBA), or use a text/hex viewer to spot readable URLs or strings.
  • 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:

    Sureshaddin.xla -

    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

  • If no Developer tab: File → Options → Customize Ribbon → enable Developer.
  • Search VBA for suspicious code patterns: Shell, CreateObject, URLDownloadToFile, Base64, Execute, WScript, FileSystemObject, API calls, Windows registry edits.
  • If you prefer no Excel: open file with a ZIP/7-zip tool (may not show VBA), or use a text/hex viewer to spot readable URLs or strings.
  • 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: