Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
protected worksheet
I have prepared a worksheet for user entry in which there are formulas.
The worksheet is protected and I am trying to have interim reports printed using a macro. When the current region is selected in the macro, the entire area including empty cells with the formulas copied, is selected. How do I get the print area to stop at the point where data has been entered, excluding the empty, formatted rows. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet protected | Excel Discussion (Misc queries) | |||
Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
Protected worksheet | Excel Worksheet Functions | |||
Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
Is worksheet protected? | Excel Programming |