Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 13th 06, 07:45 AM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 2
Default How do I protect selected cells on my worksheet?

I have a worksheet/workbook which is used by different Cashiers to summarise
their daily Bankings at the end of each. The worhsheet has columns on which
data is entered and totals are calculated in one column where I have put
formulae. I often have problems with some Cashiers who erroneuosly errase
fumulae by touching wrong buttons. how do I protect the cells which have
formulae so that no one type in anything to avoid errasind the formulae?

  #2   Report Post  
Old September 13th 06, 06:27 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default How do I protect selected cells on my worksheet?

The easiest thing to do is to protect ALL the cells and then un-protect only
those cells the user is allowed to modify.
--
Gary's Student


"Abraz" wrote:

I have a worksheet/workbook which is used by different Cashiers to summarise
their daily Bankings at the end of each. The worhsheet has columns on which
data is entered and totals are calculated in one column where I have put
formulae. I often have problems with some Cashiers who erroneuosly errase
fumulae by touching wrong buttons. how do I protect the cells which have
formulae so that no one type in anything to avoid errasind the formulae?



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
How can I have formatting toolbar active for the unprotected(unlocked) cells of the protected worksheet??? sanam Excel Discussion (Misc queries) 6 July 20th 06 01:42 PM
Is there a way to protect individual cells in a worksheet? let me know Excel Worksheet Functions 1 October 3rd 05 05:40 PM
how do i protect cells in a shared worksheet Debi Excel Discussion (Misc queries) 3 September 30th 05 11:15 PM
How do I protect a worksheet from being opened inside a workbook J. Robinson Excel Discussion (Misc queries) 2 June 1st 05 03:40 PM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 08:09 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017