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: 4
Default show value but hide function

Hi,

I have a macro the works great and does a lot. Now I want some cells
to show the results I got but hide the functions and calculations
behind them. As of now if someone clicks on the cell they can see the
formula that was used to get the result. I was them to only see the
result and not be able to see (or change) the formula. Is there any
way to do this?

-Idan

 
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
Show zero value but hide NA KateB Charts and Charting in Excel 4 June 3rd 10 03:25 AM
Show/Hide Inez Excel Discussion (Misc queries) 1 July 8th 09 03:29 PM
show hide row if Wanna Learn Excel Discussion (Misc queries) 2 May 15th 09 06:08 PM
Show and Hide in Datafield Fullam Excel Discussion (Misc queries) 0 April 17th 06 12:26 PM
Hide and show Cl Excel Programming 1 January 3rd 04 03:45 PM


All times are GMT +1. The time now is 11:58 AM.

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"