A though one but the answer is probably NO !

R

Richie

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
 
A

ankur

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
Click to expand...

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
 
N

Nikos Yannacopoulos

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
 
B

Bob Phillips

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.

--
---
HTH

Bob

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