Originally Posted by joeu2004[_2_]

"Spint" wrote:
when ever i type Cos in VBA editor , as soon as i hit
enter Cos is changing to COS.
I actually tried to create a function named COS [...].
But i deleted, since then whenever i type Cos it is
changing to COS.

Right, that was my experience when I tested this. Simply creating any
variable named COS, then deleting it causes VBA to remember that Cos was
once written COS. And AFAIK, nothing will change that except....

Replace COS with myCos (any capitalization will do) throughout the module,
export it, and remove it. Then save and close the workbook.

Reopen the workbook, import the module, and replace myCos with Cos. Save
the workbook.

Note: I tried this with only one module. You might need to experiment
further if you have multiple modules. Worst-case scenario: you might need
to export and remove every module.