| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I am trying to create a spreadsheet for businesses within zip code | Excel Worksheet Functions | |||
| VB code to copy sheet format to another sheet | Excel Discussion (Misc queries) | |||
| Copy code to a new spreadsheet | Excel Discussion (Misc queries) | |||
| Enabling macros while the sheet being protected ! | Excel Discussion (Misc queries) | |||
| Can i see code and spreadsheet simultaneously | New Users to Excel | |||
Threaded Mode
