Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everyone,
I've got a workbook that users fill in scores against a number of questions and it calculates scores for each sheet and then total score. The worksheet has a number of macros to help with the calcs but most are formulas on each of the sheets so I have used protect interface. My problem is that the last sheet of the book has three columns to allow users to make additional comments. I've used three rows resized to about 150 and merged and text wrapped. Protection is off on these cells. I don't know if this is the right approach or not??? What is happening now is that the text in the formula bar is obscuring the cells on the sheet. Is there a programatic solution or is there a way to get a message box telling the user to clear the tick in View Formula Bar and then one saying turn it back on..... If anyone could help or make a suggestion it would be very much appreciated. - Diddy(confused and ready for Home) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to prevent text overflow into adjacent blank cells | Excel Discussion (Misc queries) | |||
copy formula into the subsequent cells, not contents | Excel Discussion (Misc queries) | |||
formula that takes part of a cells contents to another | Excel Programming | |||
If formula evaluating 2 cells contents | Excel Worksheet Functions | |||
How to check if cell contents overflow. | Excel Programming |