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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Dave

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

Forum statistics

Threads
1,214,950
Messages
6,122,438
Members
449,083
Latest member
Ava19

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