How to remove a User Defined Function please

Hi

I entered my first User Defined Function so I could use this formula "US2DEC" in excel.

I followed these instructions ...

Go to the Visual Basic editor (Alt + F11) and copy and paste the function below

Code:

Function US2DEC(US) as Double

If US < 0 Then
US2DEC = 1 / (US / (US -100))
Else
US2DEC = 1 / (100 / (US + 100))
End If

End Function

I used Alt+F11 to open the editor and Pasted all the code in the blank space that was just opened.
I closed the editor and saved the workbook as a macro enabled workbook (.xlsm extension).

However when I enter any information now I get ...

Ambiguous name detected: US2DEC

I can't get back to the module I created to delete it.

I was better off just to enter the formula manually.

Can anyone help please?

I think the easiest way to get rid of it is to Re-Save the file as a NON Macro Enabled workbook (.xlsx)
You'll get warnings that macros will be deleted, let it save anyway.

Thanks for the fast reply Jonmo...

I actually tried that before and just tried again and the window still comes up when I enter a new value.

You'd have to then CLOSE the book, and RE-Open the new book (with the .xlsx extention)

That worked fine.

Thanks so much for your help.

Sorry for the newb question.

Rep added.

You're welcome.