View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Arsenio Oloroso Arsenio Oloroso is offline
external usenet poster
 
Posts: 14
Default Problem protecting cells in a mult-page workbook

I've got a multi-page workbook in which most of the pages are identical.
There are a number of ranges in these pages which I'd like to lock because
they contain formulas. But i can't seem to make it happen.

I followed the directions in my manual after grouping the sheets. I
selected a worksheet; deselected the locked option in the protection tab;
selected the ranges that I wanted to protect; and went back to the
protection tab to lock my selections. But when I went back to
"tools/protection," the option to "protect sheet" was grayed out.

This option was available when I protected only one of the sheets. Why
doesn't it work when I group a bunch of sheets together? How can I make
this happen? I really don't want to have to do this one sheet at a time.

Thanks much for any leads.
Arsenio.