LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default locking formulas in Excel 2007 so users can't change but can vieworiginal formula?

Hi All:
Is there a way to lock formulas in Excel 2007 so users can't change
but can view original formula? I can lock/protect a selected group of
cells within a worksheet, but I wan't other users to be able to review
the formulas from which the data is derived. Currently when you lock/
protect a group of cells, you can't see the formula.

Grateful for your expertise!
Verna
 
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
Locking only one cell in Excel 2007 mahan8 Excel Discussion (Misc queries) 2 July 29th 08 09:51 PM
How can I hide a formula in Excel 2007 from other users seeing it Carrie Excel Discussion (Misc queries) 3 July 22nd 08 11:10 PM
How do I freeze a formula so other users can't change it? Ann Excel Discussion (Misc queries) 1 October 16th 07 05:08 PM
excel 2007 file locking TMC Excel Discussion (Misc queries) 0 February 6th 07 04:08 PM
Locking cells only for certain users [email protected] Excel Discussion (Misc queries) 1 January 16th 06 03:39 PM


All times are GMT +1. The time now is 06:26 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"