| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Protecting print area?
Is it possible to lock the print area somehow in an Excel document?
Thanks |
|
#2
|
|||
|
|||
|
I don't know of any way to lock the print area. You could add code to
the workbook's BeforePrint event, and set the print area there. However, if users don't enable macros, the print area won't be set. For instructions on storing and using macros, you can read David McRitchie's notes: http://www.mvps.org/dmcritchie/excel/getstarted.htm Sabrina D wrote: Is it possible to lock the print area somehow in an Excel document? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Dynamically Set Print Area | Excel Discussion (Misc queries) | |||
| Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) | |||
| Changing print area | Excel Discussion (Misc queries) | |||
| How do I only show print area in excel? | Excel Discussion (Misc queries) | |||
| print a specific area within a worksheet by clicking on print? | Excel Worksheet Functions | |||
Hybrid Mode
