Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ed Ed is offline
external usenet poster
 
Posts: 279
Default Prevent Others from seeing a formula

How do I prevent from other to see the formula contained in a cell?

thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default Prevent Others from seeing a formula

You can hide the formula but it requires you to protect the sheet. In the
Format Cell dialog there is a tab called protection. On that thab select
Hidden. Now when you protect the sheet the formula will not be visisble.
--
HTH...

Jim Thomlinson


"Ed" wrote:

How do I prevent from other to see the formula contained in a cell?

thanks

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
Is it possible? DakotaNJ Excel Worksheet Functions 25 September 18th 06 09:30 PM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
How do I prevent Excel from plotting a cell w/ a formula as a "ze. Hatchet_Jack Charts and Charting in Excel 1 February 9th 05 10:31 PM
How do I prevent Excel from plotting a cell w/ a formula as a "ze. Bearclaw Chris Charts and Charting in Excel 0 February 9th 05 04:59 PM
How do I prevent incorrect formula results appearing in cell? Marc Todd Excel Worksheet Functions 2 January 26th 05 07:57 AM


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