printing protected cells

[Guest]

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

 

[Dave Peterson]

I've never seen anything like this.

You may want to provide more details.

 

[Guest]

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

 

[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.)

 

[Guest]

dave, thanks. option #2 is the one that works best for us.