printing protected cells

M

M.GONZALEZ

I am trying to print an excel worksheet where I have protected cells.
I can't seem to be able to print them unless I unprotect the entire sheet.
thanks
 
M

M.GONZALEZ

sorry, I can print the entire page. However, someone else it trying to print
just a few lines at a time. he is trying to print selection only, from the
print option.
and since he cant select the protected cells, they wont print.
Manny
 
D

Dave Peterson

If the user can't select a range, then it'll be very difficult to print what
they want to select.

I think that the solution is either to:
#1. unprotect the worksheet
#2. protect the worksheet without the stopping the selection of protected cells
#3. print it someother way
Maybe using code:
alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
activesheet.range("c12:e99").printout
(change the range to what you need.)
 
Top