Puzzling Memory Error !

I have a macro that runs fine if I open the visual basic editor and
run from there, but if I use the run button on the excel visual basic
toolbar it results in a memory error (could not be written) in exactly
the same place every time.

Why should it be doing this !
If it helps anybody, The macro generates a large number of
commandbuttons on a number of sheets at specified places.

I can't understand why it will run OK from the visual basic editor but
not from excel itself.

Can anybody shed any light to this ?

Cheers
Donna

Not without seeing your code! Sounds like something real simple.

--
|
+--Thief_
|


"Donna" <[email protected]> wrote in message
news:[email protected]...
> I have a macro that runs fine if I open the visual basic editor and
> run from there, but if I use the run button on the excel visual basic
> toolbar it results in a memory error (could not be written) in exactly
> the same place every time.
>
> Why should it be doing this !
> If it helps anybody, The macro generates a large number of
> commandbuttons on a number of sheets at specified places.
>
> I can't understand why it will run OK from the visual basic editor but
> not from excel itself.
>
> Can anybody shed any light to this ?
>
> Cheers
> Donna