How to find my VBA function or subroutine

SinceV2

New Member
Joined
Aug 29, 2024
Messages
7
Office Version
  1. 365
Platform
  1. Windows
In the last few years, Excel seems to like to hide my subroutines. I open developer and whether I select VBA or macros -non of my functions are displayed. They exist -the spreadsheets are making calls to the functions and they are working. But where the heck is Microsoft hiding them?

See Screenshot01.jpg: None of the options in this menu will display, or even list, the VBA subroutines in my workbook or the Excel file.
See Screenshot02.jpg: Nothing I select here will display, or list, the subroutines (functions) in my workbook or Excel file. It does show a clearcells macro that I no longer use.

Again, to be clear, the visual basic routine Tube_DP(A, B, C) is working in this spreadsheet.

Is there some option somewhere that needs to be turned on?
Screenshot03 and Screenshot04 show my macro security settings from the Excel Developer menu

This must be a "me" thing since I don't see a lot of people posting this problem.
 

Attachments

  • Screenshot01.jpg
    Screenshot01.jpg
    125.5 KB · Views: 7
  • Screenshot02.jpg
    Screenshot02.jpg
    76.7 KB · Views: 11
  • Screenshot03.jpg
    Screenshot03.jpg
    129.5 KB · Views: 8
  • Screenshot04.jpg
    Screenshot04.jpg
    182.8 KB · Views: 13

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Then the personal book is closed therefore use previous suggestions. In VBA use the View menu and select Project Explorer.
 
Upvote 1
That function will never have been visible in the macro dialogue box, as it needs arguments passed to it.
In the VB Editor, select View & then Project explorer.
That did it! Developer>Visual basic>View>Project Explorer>Modules
Quite the path! Thanks to you and Trevor G. The left column is a bit crowded since I've got two workbooks open. I go years between doing VBA code. The example below is from 1994. I've created more in recent months, but once I closed the edit box, I couldn't find them again.

1724957020957.png
 
Upvote 0
Glad we could help & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,223,884
Messages
6,175,174
Members
452,615
Latest member
bogeys2birdies

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