LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reference & update destin. cells on 1st machine from source workbook on 2nd machine. [email protected] Excel Discussion (Misc queries) 6 February 28th 06 05:15 AM
Turn Off Continuous Page Numbering in Workbook FuadsCurse Excel Discussion (Misc queries) 0 February 7th 06 10:06 PM
Page Numbers Aurora Excel Discussion (Misc queries) 0 November 17th 05 08:04 PM
Update linked cells within a workbook??? Chance224 Links and Linking in Excel 4 January 21st 05 06:33 PM
Delete contents of unprotected cells in workbook BD7447 Excel Worksheet Functions 1 November 6th 04 05:41 PM


All times are GMT +1. The time now is 03:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"