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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

editing cells automatically??? 1
Excel Excel spreadsheets opening at top instead of bottom. 4
Excel shortcut options 0
User is not prompted to update links when opening spreadsheet 2
INDIRECT doesn't retain data from external worksheets 2
Excel Spreadsheets keep moving 0
Will not auto open .jpg 1
How do I get rid of expired links 3

Back
Top