Aside from creating a flag and adding to the macro, you could just click the
Design Mode icon on the Visual Basic toolbar, which won't allow code to run,
then exit design mode when the macros should run.

--
Tim Zych
SF, CA

"Roger on Excel" wrote in message
...
I have some visual basic code on a sheet which i use to provide a certain
layout of the sheet for printing.

The nature of the code is complicated and slows the spreadsheet down when
i
am editing it.

Is there an easy way to deactivate the code temporarily so that i can edit
the spreadsheet without the code being active?

At present i have to manually delete the entire code and then re paste it
to
reactivate it.

It would be great if i could set up a macro such that I could push a
button
on the sheet to deactivate and activate the code