A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Locking Fomulas



 
 
Thread Tools Display Modes
  #1  
Old April 13th, 2010, 06:23 PM posted to microsoft.public.excel.newusers
Rahn
external usenet poster
 
Posts: 1
Default Locking Fomulas

How can I lock the formulas in a woorksheet but allow others to add
information in it without deleting the formulas. (Excel Office 2007 )
Thanks,
Rahn

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.newusers
  #2  
Old April 13th, 2010, 07:44 PM posted to microsoft.public.excel.newusers
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default Locking Fomulas

EXCEL 2007

Take the following actions assuming that the range that you wish to, "lock"
is D 83 to D 85.

1. Go into you Worksheet and click on cell to the left of column A and above
the number 1.

This should highlight the whole Worksheet.

2. Ctrl + 1 (at the same time) / Custom Lists pane should launch (sometimes
this window has a different name because there is a bug in the software here)
/ go to the Protection tab / remove the tick (check) from the Locked field
and hit OK.
3. Now go back to your Worksheet and highlight cells D83 to D 85 only / Ctrl
+ 1 again / Custom Lists should launch / go to Protection tab again and place
a tick (check) in the Locked field / OK.

4. Home tab / Cells group / Format / Protect Sheet / Protect Sheet window
should launch / put a password of your choice in / hit OK / put password in
again / OK.
5. Now to test that it has worked go back to cells D 83 to D 85.

If you try to enter info into any of those 3 cells you will not be able to
but you will be able to see the formulas there.

6. You should be able to enter data into all other cells in the Worksheet.

If my comments have helped please hit Yes.

Thanks.



"Rahn" wrote:

How can I lock the formulas in a woorksheet but allow others to add
information in it without deleting the formulas. (Excel Office 2007 )
Thanks,
Rahn

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.newusers

  #3  
Old April 13th, 2010, 07:49 PM posted to microsoft.public.excel.newusers
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Locking Fomulas

By default all cells on a sheet are locked when you protect the sheet.

Best is to select all cells by CTRL + a and unlock all by going to
FormatcellsProtection Tab.

Then select those cells which you want locked(formula cells) and set them to
locked.

Now protect the sheet. Users can edit unlocked cells.

See options for allowables when go to ToolsProtect Sheet

BTW...........why is this a suggestion for Microsoft?

The feature currently exists.


Gord Dibben MS Excel MVP

On Tue, 13 Apr 2010 10:23:01 -0700, Rahn
wrote:

How can I lock the formulas in a woorksheet but allow others to add
information in it without deleting the formulas. (Excel Office 2007 )
Thanks,
Rahn

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.newusers


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:47 PM.


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