How Insert Code to Private Sub Form_Open by VBA Code?

[smd7m]

Hi How can insert a few lines of code to the top surface Form_Open in all forms. Also, if this procedure did not exist, be created automatically.

 

[boblarson]

There may not be something that does exactly what you want but there is MZ Tools (free) which has both the ability to insert code from templates when you click a certain key combination and it can insert headers and you can modify the headers to be what you want. You would still have to go to the open event of each form and then click the button but it could at least make it easier.

 

[smd7m]

How Insert Code to "Private Sub Form_Open" all Form by MZ Tools?

 

[NigelShaw]

So to try and decipher what you actually want to do, I estimate this-

lets say you have 100 forms. You want the same vba routine to be used when every form opens.

You can create a single routine and make it public but as for hard coding the open event for the 100 forms, I don't think it can be automated.


Nidge