3 ?s. RE: Drop downs and comments

Giganews Newsgroups
Subject: 3 ?s. RE: Drop downs and comments
Posted by:  Wayne Knazek
Date: Fri, 30 Jun 2006

What a group!  Thanks for all your previous help!

1). Can I change/edit appearance of text in drop downs?  Size in particular.
Color and bold would be nice as well.  I have numerous drop downs in my
workbook.  Unless the size of the sheet is 100% or larger, the text in the
menu drop down is very small.  Our sheets are best sized at 60% to 75%.

2). I have a workbook with about 50 tabs.  All indexed.  And all the sheets
are populated with data from 1 of 4 master sheets. (In same workbook)  Data
is input from another computer program running on a machine in the shop, into
1 of the 4 sheets.

If I insert a row on a master sheet, the rest of the workbook is "out of
sinc".  Example: If I insert a row above row 16, on the master form sheet,
all is well.  BUT . . . when I go to other sheets, the formulae in all the
rows below 15 are all "off".  Row 15 is fine.  Row 16 has become 17.  17
becomes 18.  Etc.  As in . . .

A15 of sheet 2 might be . . .  ='2000-Master Sheet 1'!A15  And all other
rows for column A would be the appropriate formula.  But then, from there
down . . .

A16 should reference '2000-Master Sheet 1'!A16 from sheet 1.  But it now
reads =''2000-Master Sheet 1'!A17  There is no row 16.  17 reads 18, etc.
And it's that way on all of the sheets.

SO . . . I either need to know how to fix this, or . . .

If someone tries to insert a row, I need a warning prompt to come up.  A
comment box.  Bells and whistles, etc.  Saying NOT to insert rows yadda yadda.

Can I associate a comment box (or whatever) with a regular Excel menu
function like "insert Row"?  Ideally, I'd like to have "insert row" unabled,
with a prompt/warning letting operators know they can't insert rows.  Or can
columns be "locked" so no one can insert a new row?  (Ditto for inserting
columns!)

3). I'm trying to figure out how to "protect???" certain columns.  I don't
want anyone fooling around with the columns that contain formulae.  And there
are a ton of them.

Actually, there are only maybe 5 to 7 colums out of 50, on only 4 sheets out
of 50  that they should be allowed to use for manually inputting data or text.

I know this is a bit long.  If you'd like to maybe answer just one or two
?s, and "pass it on", that'd be great!

Thanks again!  Wayne

Replies