LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Protecting Cells

Hello,

I need to be able to protect a range of cells on a worksheet. These cells
have formulas in them, which will return a value based on what is entered in
a particular cell. For example, if I enter the number 2 in cell A1, then A2
automatically displays "NEEDS ASSISTANCE"

Whats been happening is, users have been clearing the contents of the sheet
and erasing the formulas! My question is, what is the best way to protect
the formulas, so the workbook still allow the functions to return values
into the cells, but doesn't allow a user to change the formula?

Hope that wasn't too confusing. Thanks all!


 
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
Protecting cells Tommy Boy Excel Discussion (Misc queries) 3 October 29th 07 03:15 PM
Protecting Cells P. Zicari Excel Discussion (Misc queries) 0 October 24th 07 12:22 AM
Protecting Cells Pedro Excel Discussion (Misc queries) 2 June 8th 06 06:25 PM
Help with protecting cells Prometheus[_9_] Excel Programming 4 October 6th 05 09:59 PM
Protecting Cells Katie Excel Worksheet Functions 0 September 16th 05 03:36 PM


All times are GMT +1. The time now is 11:13 PM.

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

About Us

"It's about Microsoft Excel"