Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 25
Default Hide the formula in a cell.

Hi !! I need to hide the formula given in a particular for the user. I dont
want the user to see the actual formula given in a particular cell .How can
this be defined ?
regards
Sanjay Kapoor
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,593
Default Hide the formula in a cell.

You could unlock all cells except those formulae cell, and the protect the
sheet and uncheck the Select locked cells box. The user won't be able to
select the cells then.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"sansk_23" wrote in message
...
Hi !! I need to hide the formula given in a particular for the user. I

dont
want the user to see the actual formula given in a particular cell .How

can
this be defined ?
regards
Sanjay Kapoor



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
Hide a formula result until cell has been filled Sammy Excel Discussion (Misc queries) 13 May 19th 09 11:26 PM
HOW DO I HIDE FORMULA IN A CELL Riya Excel Discussion (Misc queries) 4 May 30th 06 12:48 PM
Formula or Macro to hide a row based on a cell value JP Excel Discussion (Misc queries) 0 February 3rd 06 06:10 PM
Use formula to hide/delete cell? Lost! Excel Worksheet Functions 3 June 3rd 05 12:05 AM
How do I add a date formula to a cell but hide the contents with . Emzy Wemzy Excel Discussion (Misc queries) 2 December 12th 04 01:48 PM


All times are GMT +1. The time now is 06:38 AM.

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"