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.