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

I've never seen anything like this.

You may want to provide more details.

M.GONZALEZ wrote:

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

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" wrote:

I've never seen anything like this.

You may want to provide more details.

M.GONZALEZ wrote:

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

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

M.GONZALEZ wrote:

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" wrote:

I've never seen anything like this.

You may want to provide more details.

M.GONZALEZ wrote:

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


--

Dave Peterson

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

"Dave Peterson" wrote:

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

M.GONZALEZ wrote:

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" wrote:

I've never seen anything like this.

You may want to provide more details.

M.GONZALEZ wrote:

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


--

Dave Peterson