Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
zeek
 
Posts: n/a
Default Shared workbook protection



Good evening,





This is my first attempt at merging a shared workbook. What I have read is
that I create a master and save it to several unique named workbook to be
distributed on a shared folder.



I can then open the master and merge the other sheets one at a time until I
have merged all of the books.



Can I protect the sheets so that some of the data can not be changed and
allow the users to add/change only certain cells? If so how is this done?



I have tried it here on my pc with multiple files and have overwritten some
of the data on purpose. I thought it was to notify you before making
changes.



Any tips would be appreciated.



Thanks lomax


  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

I think your question is: how do I protect some cells while allowing others
to be edited?

Cell protection is a two stage process. Step one is to remove the "locked"
protection format from the cells you want to allow changes to. By default
all cells have locked protection format. Select the cells you want to
unlock and then open the Format, Cells, Protection dialog box and uncheck
Locked*.

Once the appropriate cells are unlocked step two is to turn sheet protection
on via Tools, Protection, Protect Sheet.

*If you have Excel 2002 or 2003 it would be more direct to display the
Protection toolbar and use the first toolbutton "Lock Cell" to unlock cells.

--
Jim Rech
Excel MVP
"zeek" wrote in message
news:3T6vd.417$Tf5.211@lakeread03...
|
|
| Good evening,
|
|
|
|
|
| This is my first attempt at merging a shared workbook. What I have read
is
| that I create a master and save it to several unique named workbook to be
| distributed on a shared folder.
|
|
|
| I can then open the master and merge the other sheets one at a time until
I
| have merged all of the books.
|
|
|
| Can I protect the sheets so that some of the data can not be changed and
| allow the users to add/change only certain cells? If so how is this done?
|
|
|
| I have tried it here on my pc with multiple files and have overwritten
some
| of the data on purpose. I thought it was to notify you before making
| changes.
|
|
|
| Any tips would be appreciated.
|
|
|
| Thanks lomax
|
|


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
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 03:02 PM
How do I open a shared xls workbook on a PC and Mac at the same ti Debs Excel Discussion (Misc queries) 2 December 8th 04 06:25 AM
Scroll Bar in Shared workbook Ronil Patel Excel Discussion (Misc queries) 2 December 8th 04 02:49 AM
Print Chart in Shared Workbook Paul. Excel Discussion (Misc queries) 1 December 7th 04 12:47 AM
how to update a shared workbook using the same cells at the same t Blair Excel Discussion (Misc queries) 0 November 26th 04 11:21 PM


All times are GMT +1. The time now is 12:58 AM.

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"