How to find my VBA function or subroutine

[SinceV2]

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.

 

[Trevor G]

Welcome to the Forum. One way is select the macro as described is screen 2 and select the Edit button on the right. You can also look to display the project explorer and then finally right click the tab sheet name and select view Module.

 

[SinceV2]

This screenshot shows the callout for the function Tube_DP(A, B, C). The Value 1.69, in column G, is returned from this function.

 

[SinceV2]

Welcome to the Forum. One way is select the macro as described is screen 2 and select the Edit button on the right. You can also look to display the project explorer and then finally right click the tab sheet name and select view Module.

Thanks -but since I just deleted the only macro it was showing -the unused "clearcells" selecting the edit button is not an option. It is greyed out. Fundamentally, my Tube_DP function does not show in macros box. Nor does it show other functions that run in this workbook.

 

[Trevor G]

Have you tried unhiding the personal workbook?

 

[SinceV2]

Welcome to the Forum. One way is select the macro as described is screen 2 and select the Edit button on the right. You can also look to display the project explorer and then finally right click the tab sheet name and select view Module.

I don't see "project explorer". Where is that found? Here is what I have under "developer"

 

[SinceV2]

Have you tried unhiding the personal workbook?

No. Where can I find that?

 

[Trevor G]

In the VBA screen (Alt + F11 will take you into the VBA screen then use the View menu. Look at your first screen shot.

 

[Fluff]

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.

 

[Trevor G]

You should look at the View Tab in the main excel menu and see if you can unhide it.