Excel 2003 - Weird behaviour in VBA editor
In message
at 21:20:42 on Thu, 26 Jul 2007, Mike
S wrote
In message
at 14:27:42 on Wed, 25 Jul 2007, George Nicholson
wrote
I've seen that behavior in the Access VBE if there is active code running
(say, a Form timer that Break mode doesn't effect) while I am making edits.
The VBE really, really, really doesn't like that.
Again, I will have a look at this. I think while I was developing I
used the Worksheet_Activate event, but have long since changed that
(and have exported the code out since then).
It could be possible the macro is still running. I usually find
restarting works, and in the worst case I start my spredsheet and
disable macros
Many thanks
I don't think this is a possibility because I always wait for the macros
to stop running before going into the editor. I was thinking maybe it
was due to the number of occupied cells, but it's very minimal really.
Longer term, I won't be using my spreadsheet to display the contents of
the data I am reading from a file, so hopefully then the problem will go
away
--
Mike News
|