How to prevent macro from generating error if fails ...

[joe789]

Hi Folks,

I have some code being called from a AutoExec macro. The problem is, that code has some connection strings in it, so if the AutoExec fails, I don't want the traditional 'Macro Single Step' error being flashed on the screen to the user because it has the 'Arguments:' of the code inside of it ... I would rather simply just have a Msgbox saying "Error". An example of what occurs automatically when the code fails is displayed below, is there a way to overwrite this error and make it a MsgBox because I don't want folks to see the connection string in the 'Arguments' section? I am trying to prevent folks from getting to see sensative data displayed in the Arguments section of the error if the macro fails.

Thank you,

Joe

 

[pbaldy]

Does your code have error handling?

http://www.baldyweb.com/ErrorTrap.htm

 

[arnelgp]

test first if CurrentProject.IsTrusted = True.