Programming the VBA editor, VBE & Ultra Meta

[redbull]

Good morning,


Unlike a lot of posts here, this isn't going to be a "how do I do this" kind of post.

I was reading "http://www.cpearson.com/excel/vbe.aspx Programming The VBA Editor" & "http://www.cpearson.com/excel/vbemenus.aspx Creating Menu Items In The VBA Editor"


And that made me start to wonder, can we change how VBA itself acts?

For instance, when one of my users encounter an error they get the standard debug option. Now most users hit debug, take a screenshot and email me. But would it be possible to just change what the debug option is doing? (Or I could write better code, but meh)

Or maybe a password lock on code, and if the password is entered incorrectly 3 times it would erase all the modules and save/overwrite them.



So I guess the question is this, has anyone here ever had a reason to get into the VBE side of things? The meta of all metas? IF so, where can I get started?

[ranman256]

if the code has error traps, the user wont get these debug errors.
it would give a error # /location. Then you can solve it.

sub Mysub()
dim var,var3,var2
on error goto ErrTrap

' code
'code

exit sub  ' end of normal code

ErrTrap:    'start of err trap
msgbox err.description,vbWarning, "MySub::" & err

end Sub   'end of sub

[orange]

You may get some ideas and a free utility from Wayne Phillip's site