View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roger on Excel Roger on Excel is offline
external usenet poster
 
Posts: 249
Default enabling/disabling a set of code from within a spreadsheet sheet

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