Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 30th 05, 08:11 PM
Debi
 
Posts: n/a
Default how do i protect cells in a shared worksheet

is it possible to protect only cells that contian certain formulas within a
shared worksheet yet still have the values on those cells updated when
spreadsheet is opened due to links to other shared worksheets?

  #2   Report Post  
Old September 30th 05, 10:27 PM
Dave Peterson
 
Posts: n/a
Default

Yes.

Just do all your setup work before you share the workbook.

Create your formulas, lock/unlock the cells, protect the worksheet

Then share the workbook.



Debi wrote:

is it possible to protect only cells that contian certain formulas within a
shared worksheet yet still have the values on those cells updated when
spreadsheet is opened due to links to other shared worksheets?


--

Dave Peterson
  #3   Report Post  
Old September 30th 05, 10:54 PM
Debi
 
Posts: n/a
Default

Dave when you say do my setup before I share the workbook, I am not sure I
understand or perhaps I did not give the correct information at first. I am
an auditor and therefore the workbooks I am need to protect my formulas in
have already been written by someone else is it still possible to protect
those cells of after the design and data input on the workbook. Also when you
state lock and unlock the cells then protect the sheet, the only cells I want
protected are those that I have entered formulas into those are also the
cells that are updated when opening the workbook some of the remaining cells
are accessed by other for either viewing or adding data in.

"Dave Peterson" wrote:

Yes.

Just do all your setup work before you share the workbook.

Create your formulas, lock/unlock the cells, protect the worksheet

Then share the workbook.



Debi wrote:

is it possible to protect only cells that contian certain formulas within a
shared worksheet yet still have the values on those cells updated when
spreadsheet is opened due to links to other shared worksheets?


--

Dave Peterson

  #4   Report Post  
Old September 30th 05, 11:15 PM
Dave Peterson
 
Posts: n/a
Default

When you wrote shared workbook, I assumed you meant shared via tools|share
workbook.

If you just meant that you sent out copies of your workbook, then the sharing
stuff I wrote makes very little sense <bg.

Cells being locked and worksheets being protected go hand in hand.

You can lock cells (or unlock cells). But until you protect the worksheet, you
won't notice any difference.

Once you protect the worksheet, then those locked cells can't be changed(*) by
the user.

You have a couple of choices.

Lock all the cells and come back and unlock the cells you want unlocked.
or...
Unlock all the cells and come back and lock the cells you want locked.

It's just a numbers game. If there's less to do one way, do it that way.

In general...

Select A1.
hit ctrl-a (twice in xl2003) to select all the cells on the worksheet
Format|cells|Protection tab
Uncheck Locked (every cell will be unlocked).

Now with all the cells still selected
edit|goto|special|check formulas
now Format|cells|Protection tab
Check Locked (all the formula cells will be locked)

You'll probably want to lock all the cells with
headers/instructions/descriptions, too. Just select as many as you can see and
Format|cells|Protection tab
check Locked
(as much as you need)

But those locked/unlocked cells behave the same way--until you protect the
worksheet.

Tools|protection|protect sheet.
(Give it a nice memorable password)

Now the sheet's protected--the locked cells can't be changed(*) by the user.

============
(*) excel's protection is very weak. It can be broken in minutes by anyone who
knows how to make it to this newsgroup -- or can search google. This security
isn't made to protect intellectual property. It's made to stop users from
overwriting formulas.

ps. If you were trying to protect the formulas from being viewed, there's an
option under format|Cells|Protection tab|check hidden

That also doesn't do anything special until you protect the sheet.



Debi wrote:

Dave when you say do my setup before I share the workbook, I am not sure I
understand or perhaps I did not give the correct information at first. I am
an auditor and therefore the workbooks I am need to protect my formulas in
have already been written by someone else is it still possible to protect
those cells of after the design and data input on the workbook. Also when you
state lock and unlock the cells then protect the sheet, the only cells I want
protected are those that I have entered formulas into those are also the
cells that are updated when opening the workbook some of the remaining cells
are accessed by other for either viewing or adding data in.

"Dave Peterson" wrote:

Yes.

Just do all your setup work before you share the workbook.

Create your formulas, lock/unlock the cells, protect the worksheet

Then share the workbook.



Debi wrote:

is it possible to protect only cells that contian certain formulas within a
shared worksheet yet still have the values on those cells updated when
spreadsheet is opened due to links to other shared worksheets?


--

Dave Peterson


--

Dave Peterson


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
Password Protect Cells Dharsh Excel Discussion (Misc queries) 3 April 28th 05 04:12 PM
Protect Cells enquirer New Users to Excel 1 April 18th 05 10:30 PM
is there a way to protect a range of cells on a worksheet? vevans Excel Discussion (Misc queries) 1 February 17th 05 05:30 PM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
about protect just cells tjtjjtjt Excel Discussion (Misc queries) 3 December 7th 04 01:35 PM


All times are GMT +1. The time now is 05:51 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017