A though one but the answer is probably NO !

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richie - 07 Feb 2007 11:51 GMT

Howdy all,

My question is this for those who know Excel very well. I would like to
know if it possible to stop a person inserting or deleting rows or columns on
a spreadsheet just like the protection but not using the protection as data
would be entered every day and in order to enter data you can't have it
protected.

Regards

Signature

Niall

Reply to this Message

ankur - 07 Feb 2007 11:56 GMT

> Howdy all,
>
[quoted text clipped - 7 lines]
> --
> Niall

Hi Niall,

I think you can use "Allow users to edit Ranges" option in tools>>
protection
This way you can specify the range you would want the user to edit and
those u do not want to be edited.

Regards
Richard
www.xlmacros.com

Reply to this Message

Nikos Yannacopoulos - 07 Feb 2007 11:57 GMT

Richie,

The answer is indeed Protect Sheet! All you need to do is select the
whole sheet, unlock cells, then protect the sheet. This way users will
be able to enter and edit data, but not to insert or delete columns or rows.

Tip: look at the options in the Protect Sheet pop-up dialog, it gives
you many possibilities.

HTH,
Nikos

> Howdy all,
>
[quoted text clipped - 5 lines]
>
> Regards

Reply to this Message

Bob Phillips - 07 Feb 2007 11:57 GMT

You can do it with event code and having some management code behind the
sheet, but it is cumbersome and not worth it IMO.

You can protect the sheet, but unlock those cells that you want them to
input in.

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Howdy all,
>
[quoted text clipped - 7 lines]
>
> Regards

Reply to this Message