If the poster wants to prevent someone from typing
into a column accidentally they could leave such columns
protected, unprotect the others, and use sheet protection.
Another solution would be to use an Event macro to
move the active cell one to the right after activating a cell in
the column to be skipped over, or to move the active cell two cells to
the right after changing a cell in a particular column. http://www.mvps.org/dmcritchie/excel/event.htm
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.
