Blocking column insertion
 

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

Blocking column insertion
 

How does the user insert data in columns A:U?

In Excel 2000, I only see insert menus for worksheet, row, or column.
No insert data.

I'm wondering what is the reason not to lock the worksheet.

Blocking column insertion
 

Dan,

The user will type or paste data into the range....what I need to do is
prevent the user from inserting , or deleting columns in the A:U range.

"dan dungan" wrote:

How does the user insert data in columns A:U?

In Excel 2000, I only see insert menus for worksheet, row, or column.
No insert data.

I'm wondering what is the reason not to lock the worksheet.

Blocking column insertion
 

Rafi,

The only way I know to do that is to lock the worksheet.

Dan

Blocking column insertion
 

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