View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default I want to protect beyond the page break

Billi
What are you doing to "protect" a range or sheet? There are 2
parameters involved in "protecting" a range. One is the actual setting of
the protection with Tools - Protect sheet. But this, in itself, doesn't
protect anything.
The second parameter is the setting of individual cells (or ranges of cells)
to "Locked" or unlocked. This is done with Format - Cells - Protection
tab - check or uncheck the Locked box.
The two, protecting the sheet and locking the cells, go together. That is,
locking a cell does not protect the cell unless the sheet is protected. And
protecting the sheet does not protect a cell unless that cell has been set
to Locked.
So if you want to protect or not protect a range of cells, set those cells
to Locked or uncheck the Locked box. Then protect the sheet. HTH Otto
"Billi" wrote in message
...
I am creating a form for all of our employees to be able to use. I want to
protect certain cells, which I have done successfully on one page but I'm
having a hard time protecting only certain cells past the page break. I
want
to be able to add text (paragraphs) beyond the page break. Can you only
save one page per "sheet"?