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

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
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.
 
Upvote 0
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.

1724954846826.png
 
Upvote 0
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.
1724955243323.png
 
Upvote 0
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"
1724955513868.png
 
Upvote 0
In the VBA screen (Alt + F11 will take you into the VBA screen then use the View menu. Look at your first screen shot.
 
Upvote 0
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.
 
Upvote 1
Solution
You should look at the View Tab in the main excel menu and see if you can unhide it.
 
Upvote 0

Forum statistics

Threads
1,223,879
Messages
6,175,148
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