Hi
How do you go about setting the data entry order into cells in a protected sheet? Is there a database-type function that lets you determine the order for entry?
Hi
How do you go about setting the data entry order into cells in a protected sheet? Is there a database-type function that lets you determine the order for entry?
Last edited by BRISBANEBOB; 11-20-2010 at 08:21 PM.
before you protect the sheet select any cells you want to be editable and in format/cells/protection make sure they are not locked (ie uncheck the locked option)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi Martin
Done that but once I reprotect the sheet the cursor does not tab to the unprotected cells in the order I need. I do I change that order?
afik tab tabs from left to right then down thats it
Thanks - much appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks