ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Freeze row height then allow the user to view all with a button (https://www.excelbanter.com/excel-discussion-misc-queries/73569-freeze-row-height-then-allow-user-view-all-button.html)

Graham Smith 450-458-0101

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




All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com