a 100% working project it has 1 SUB that isn't included in the module's "macro browser"

davidsharpe

New Member
Joined
Sep 26, 2015
Messages
2
[SIZE=+1]I have a working project (a number of subs in 500+ lines of code in one module) [/SIZE][SIZE=+1]but there is something weird. One of the subs is not displayed in the dialog that [/SIZE][SIZE=+1]pops up when (tools ->macro -> macros).

1)I initially
[/SIZE][SIZE=+1]thought that the naming [/SIZE][SIZE=+1]was a problem[/SIZE] [SIZE=+1][/SIZE]
[SIZE=+1]"Sub E_Save_Excel_As_PDF(theLabel As String)" [/SIZE][SIZE=+1]; but renaming
[/SIZE]
[SIZE=+1]"Sub F(theLabel As String)" changed nothing.[/SIZE]
[SIZE=+1]2)I created a new .xlsm.[/SIZE]
[SIZE=+1]I just added a module and only included my sub in it.[/SIZE]
[SIZE=+1]Any guidance would be appreciated; here is the coding for the Sub
[/SIZE]
[SIZE=+1]++++++++++++++++++++++++
[/SIZE]
[SIZE=+1]Sub F(theLabel As String)
'Sub E_Save_Excel_As_PDF(theLabel As String)

Dim FileNameToUse As String
FileNameToUse = "D:\HUMANA\Humana-GO365\Summary_Reports"
FileNameToUse = FileNameToUse & theLabel & ".pdf"

Sheets("Summaries").Range("E1:J27").ExportAsFixedFormat _
Filename:=FileNameToUse, _
Type:=x1TypePDF
Sheets("diariesXXX").Activate

End Sub
[/SIZE]
[SIZE=+1]++++++++++++++++++++++++++++++++++
[/SIZE]
[SIZE=+1]Thanks[/SIZE]
[SIZE=+1]Dave[/SIZE]
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
Dave

Subs that require arguments won't appear in the Macros dialog.
 
Upvote 0

Forum statistics

Threads
1,215,005
Messages
6,122,661
Members
449,091
Latest member
peppernaut

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