Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 385
Default Lock cells in a shared workbook

I have a workbook that I have shared among a group of people. I would like
to be able to "lock" certain cells but it is not allowing me to enter in
protection after I share and protect. Is this possible?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default Lock cells in a shared workbook

Nope... You can not change the protection on a shared workbook without first
unsharing it. In Help type in Shared workbook restrictions to find a complete
list of the features that are unavailable...
--
HTH...

Jim Thomlinson


"Jennifer" wrote:

I have a workbook that I have shared among a group of people. I would like
to be able to "lock" certain cells but it is not allowing me to enter in
protection after I share and protect. Is this possible?

Reply
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
Shared workbook, on network, file lock markb72 Excel Discussion (Misc queries) 0 September 28th 07 02:40 AM
Lock cell in a shared workbook Raj New Users to Excel 1 December 17th 06 11:53 AM
Lock cells in shared workbook Raj Excel Worksheet Functions 0 December 16th 06 01:51 AM
Merging of cells while in shared workbook Narnimar Excel Discussion (Misc queries) 2 September 18th 06 05:26 PM
I want to lock the printing preferences in a shared workbook The Swimmer Setting up and Configuration of Excel 1 March 7th 06 04:51 PM


All times are GMT +1. The time now is 05:22 PM.

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

About Us

"It's about Microsoft Excel"