LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Graham Smith 450-458-0101
 
Posts: n/a
Default Freeze row height then allow the user to view all with a button

I am creating a script/questionaire that will be used by different people. I
would like to create a form (Excel?) where I could enter a question in one
cell then wrap the text in the answer cell, allow the person who is writing
the answer to use as man lines as they want but freeze the height of the
answer cell (to 3 lines) - THEN put a 'button' on/near the answer cell that
would allow someone viewing the completed questionaire to choose wether they
want to view the entire answer.... phew. I've got everything done (thanks to
the forum) except for the 'putting the button on/near the cell to view the
entire contents' part. I know I can just select the cell and go to row -
auto fit but is there another way.
Thanks


 
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
Excel - merged cells w/wrapped text auto row height doesn't work. Fred Excel Discussion (Misc queries) 0 October 21st 05 02:11 PM
Resizing row height to dynamically fit height of text box Jon Excel Discussion (Misc queries) 1 August 8th 05 01:37 PM
Is it possible to view or size column width and/or row height in . GeoMulak Excel Discussion (Misc queries) 1 April 13th 05 11:27 PM
Autofitting a row Josephine Excel Discussion (Misc queries) 2 March 3rd 05 03:37 PM
A "previous" button on a user form Anthony Slater Excel Discussion (Misc queries) 3 November 29th 04 05:57 PM


All times are GMT +1. The time now is 01:23 PM.

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"