LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
KathyHL
 
Posts: n/a
Default Partially protect a cell?

Is there a way that I can protect the formula in a cell, and its format, but
still allow a user to change the contents? It's for an expense report. The
users need to enter their amounts, but the cells have formulas that need to
be protected.

Thank you!
 
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
Cell color based upon cell value My View Excel Discussion (Misc queries) 11 July 6th 05 03:59 AM
Protect Cell Formatting Bill Schnur Excel Worksheet Functions 1 March 23rd 05 02:53 AM
protect cell bayanbaru Excel Worksheet Functions 2 February 14th 05 09:15 PM
How do I protect one cell in a spreadsheet? [email protected] Excel Worksheet Functions 1 November 2nd 04 04:33 PM
VLookup resulting in a blank cell... KempensBoerke Excel Worksheet Functions 1 October 28th 04 09:57 PM


All times are GMT +1. The time now is 09:01 PM.

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"