Find and remove User Defined Functions

Moosles

New Member
Joined
Apr 1, 2021
Messages
23
Office Version
  1. 2019
Platform
  1. Windows
I am updating an old workbook which was created years ago, and when sending to others for their review they are getting the following message:

Error.PNG

There used to be a User Defined Function in a VBA module but I deleted this as it was not needed. I can't seem to find the isformula User Defined Function anywhere else in the workbook, but I'd like to be able to delete it so that this error message goes away, how would I do this? The function is used nowhere in the file and is not referenced anywhere else in the VBA, but I'd like to get rid of this message - any ideas?
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
If you go into a cell and type =isfor you should get a drop down list of suggestions. Do you get 1 or 2 isformulas in the drop down box ?
If you get 2 then there is a function kicking around in there somewhere.
1) In the VBA project window try Ctrl+F enter isformula in the search box. Tick the In Project box and hit enter.
If you don't find anything
2) Disable any Add-Ins that you might have enabled and see if that fixes it.
 
Upvote 0

Forum statistics

Threads
1,224,828
Messages
6,181,201
Members
453,022
Latest member
RobertV1609

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top