LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 158
Default Displaying results in formula bar when cell is hidden

Is there any way to have the results of a formula appear in the formula bar
when the cell is protected and hidden, and sheet protected? I have formulae
that retrieve text, but the cells are not wide enough to display all that
text, and the formula bar shows nothing (blank) when the cell is protected
and hidden, and the sheet is protected. I think my alternative is how excel
should work . . .

TIA

Andy
 
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
DISPLAYING RESULTS OF A FORMULA jay1004x Excel Discussion (Misc queries) 1 May 1st 09 04:11 PM
excel 2007 formula results not displaying Txlonghorn76 Excel Discussion (Misc queries) 11 November 20th 08 01:41 PM
IF formula results not displaying JC Excel Worksheet Functions 1 May 29th 08 07:09 PM
Displaying Formula Results in Cell macshimi Excel Discussion (Misc queries) 3 April 11th 06 07:47 AM
Displaying formula rather than results... RUSH2CROCHET Excel Discussion (Misc queries) 3 April 10th 06 05:21 PM


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