VBA Run Time error 13 Type Mismatch

[GRCArizona]

Hi - I've got a work file where the following is occurring:

When the VBA Project is locked, and I run a macro, I'm getting a VBA error "Run Time Error 13 Type Mismatch". I close down the file with out saving, re-open, unlock the VBA Prjoect and run the macro, it works fine.

Anyone come across this before? Why would locking the VBA Project editor impact the macro?

Any advice is greatly appreciated.

thx,

GRC

 

[ranman256]

at some point , a string value is trying to save into a numeric field.
either in the vba
or a field.

(or a control tries to store into a variable)