View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jared Jared is offline
external usenet poster
 
Posts: 109
Default Error Message When running code but not stepping through it.

Ron,

I'm using Excel 2002. I should have wrote that in the first post. Sorry.

"Ron de Bruin" wrote:

Hi Jared

If you are using Excel 97 then try this

Try to Change the takefocusonclick property to false of the button
This is a bug in Excel 97


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Jared" wrote in message ...
I'm attempting to use VBA to add a Command Button to a Worksheet. When I step
through the code (using F8) it works fine. However, when I simply try to run
it, Excel crashes and I get the error:

The instruction at '0x650e7624' referenced memory at '0x053c831c'. The
memory could not be read.

Any idea what is going on?