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

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
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,223,911
Messages
6,175,337
Members
452,637
Latest member
Ezio2866

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