API reference
Others
Control Excel application settings and find worksheets by CodeName.
3 public procedures0 enumerations
New OthersFunctions and procedures#
Excel utilities#
| Name | Description |
|---|---|
SetMacroMode | Disables Excel screen updates, events and alerts, and selects manual calculation. |
DisableMacroMode | Enables Excel events, screen updates and alerts, and selects automatic calculation. |
Get_WS_Codename | Looks up a worksheet in ThisWorkbook by its VBA CodeName. |
Using this class#
The class has VB_PredeclaredId = False. Use an instance, or a shared instance declared in a standard module.
Dim utility As Others
Set utility = New Others
' Existing project global instance: Others