to reset the VBE window everytime you open the db.
1. change the public sub in post #2 to a public function.
2. create a macro (name it Autoexec), that do a RunCode of the Public Function in 1.
to reset the VBE window everytime you open the db.
1. change the public sub in post #2 to a public function.
2. create a macro (name it Autoexec), that do a RunCode of the Public Function in 1.
You can also add an autokeys macro entry to close all open VBE windows on demand
See my article Close All VBE Windows