Rafi, since this is so much later, I hope you have already figured out how to
enable what you are attempting. If not, see the following.

Protecting a worksheet doesn't have to protect all cells from being used.
There has to be protection for individual cells for the worksheet protection
takes effect.

You could always select columns A through U (click column header "A", make
sure column U is viewable, hold Shift and click "U") Format Cells
Protection uncheck the check-box.

Now protect the worksheet, making sure column insertion and deletion are not
available for users, then save it.
--
Brad E.


"Rafi" wrote:

How do I prevent users from inserting columns without locking the worksheet?
The user has to insert data in columns A:U however, I need to prevent them
from inserting columns anywhere between column A and column U

Thanks

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming