Home > Net >  Changing "Private Sub Procedure1" in Form1 to "Public -" (Form1) from Form2
Changing "Private Sub Procedure1" in Form1 to "Public -" (Form1) from Form2

Time:09-22

In Form1 Procedure1 is private. I need to change declaration in public from Form2 with VBA.

In Form2 I'm looking for a command like that:

Private Sub Procedure2_Click ()

Form_Form1.Declaration Public

End Sub

The previous code will change From1 from

Private Sub Procedure1 ()
blablabla
End Sub

To

Public Sub Procedure1 ()
blablabla
End Sub

much appreciated

CodePudding user response:

You can't do such a thing. The access modifiers (Private/Public) are static. When you try to call a Private Sub from another object, the code cannot be complied and thus cannot be run. Since such a code cannot be run, there is no way to create a Sub that would change a Private Sub to a Public Sub.

Well, unless you are writing a tool as an add-in that you would call at design time. I once wrote a code formatter like this. But this code cannot be run at the run-time of your application.

  • Related