Any time you are in code module and screwing with it the entire
project can be reset. Sometimes you notice it and sometimes not.
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"atpgroups"
wrote in message
On 3 Jun, 23:32, "Jim Cone" wrote:
Other things...
Running code from the VBE can cause global variables to die.
OK, I will bear that in mind. Actually that might explain some of my
issues. Are you saying that invoking a procedure from the immediate
window or using run/F5 leads to a different behaviour to invoking the
code via a button or menu?
Global Variables should be declared in a standard module.
They are. In fact I have a whole module dedicated to globals,
constants, enums and DLL declarations.
There is no chance that the DLL calls are causing the module to look
different to the compiler?