Avatar of Justin Smith
Justin Smith
Flag for United Kingdom of Great Britain and Northern Ireland asked on

how to change a Pruvate subroutine

hi, I am trying to make an Excel Private macro to appear in the Assign macros box. This is this code
Private  SendEmail (ByVal EmailRow as integer, ByVal EmailStatusRange as string)
I took out the word Private but I still cannot see it. please help.
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Fabrice Lambert

8/22/2022 - Mon
gr8gonzo

Try adding the word "Sub" in the:

Private Sub SendEmail(...etc ..)

To be honest, I'm not sure I've ever done (or needed to do) a private subroutine in an Excel sheet before. What's your reason for wanting to use a private scope instead of public?
ASKER CERTIFIED SOLUTION
Subodh Tiwari (Neeraj)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Fabrice Lambert

hi, I am trying to make an Excel Private macro to appear in the Assign macros box.
Private macros never ever appear in the Assign macro dialog box, due to their nature:
They are private, intended to be called internally only, thud not visible from the outside (the Assign macro dialog box is already an "outside" feature).
Your help has saved me hundreds of hours of internet surfing.
fblack61