How do I set spreadsheet to "open for editing" automatically?

T

Tom Hutchins

You can only have 7 IF statements in a single formula. Use Vlookup instead.
Create a table (could be on another sheet) of your 11 answers and their
corrpesponding letters. For example, if this table is on Sheet5, starting in
cell A1, the Vlookup for cell B10 (which has the answer selected from the
drop down box) might be:

=VLOOKUP(B10,Sheet5!A1:B11,2,FALSE)

Hope this helps,

Hutch
 
P

pdberger

Chelsea --

Sorry, but don't understand. Normally a workbook opens and is open to be
edited and changed. If your workbooks open protected, and you have to go
through a password process, then I wonder if your 'Book1' has been saved with
password protection activated somehow. If that sounds like what's going on,
you might want to open it up, do nothing except check to see if there's a
password set up. If so, remove the password and do nothing else except save
it back where it was as Book1. I suspect that would fix that problem.
 
Top