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: 155
Default Contents of Formula Bar overflow cells

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
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
how to prevent text overflow into adjacent blank cells Bobby Excel Discussion (Misc queries) 1 December 27th 08 11:46 PM
copy formula into the subsequent cells, not contents Janis Excel Discussion (Misc queries) 1 July 30th 07 11:38 PM
formula that takes part of a cells contents to another Jennifer Excel Programming 3 July 3rd 06 05:52 PM
If formula evaluating 2 cells contents N E Body Excel Worksheet Functions 3 August 17th 05 06:54 PM
How to check if cell contents overflow. Alan Savage Excel Programming 1 September 29th 04 02:42 PM


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