How to protect a range
 

Hi,

Is there a way to protect a range in a worksheet, without protecting the
entire range?

Thanks for your help

How to protect a range
 

Hi Jeff,

by default all cells are locked, what you could do it selecte entire ws,
FORMAT | CELL | PROTECTION | uncheck LOCKED

Than select just the range that you are thinking to protect and locked the
cells, protect the ws

HTH
Regards from Brazil - going to the 6th *
Marcelo

"Jeff" escreveu:

Hi,

Is there a way to protect a range in a worksheet, without protecting the
entire range?

Thanks for your help

How to protect a range
 

Hello,

If I protect a range of cell, people won't be able to insert any rows within
the range. I would like to know if there is a way to allow people to insert
row when cells are protected.

Thanks!

Alex

"Marcelo" wrote:

Hi Jeff,

by default all cells are locked, what you could do it selecte entire ws,
FORMAT | CELL | PROTECTION | uncheck LOCKED

Than select just the range that you are thinking to protect and locked the
cells, protect the ws

HTH
Regards from Brazil - going to the 6th *
Marcelo

"Jeff" escreveu:

Hi,

Is there a way to protect a range in a worksheet, without protecting the
entire range?

Thanks for your help

How to protect a range
 

If you're using xl2002 or higher, you can protect the sheet and still allow the
user to insert rows.

Alex wrote:

Hello,

If I protect a range of cell, people won't be able to insert any rows within
the range. I would like to know if there is a way to allow people to insert
row when cells are protected.

Thanks!

Alex

"Marcelo" wrote:

Hi Jeff,

by default all cells are locked, what you could do it selecte entire ws,
FORMAT | CELL | PROTECTION | uncheck LOCKED

Than select just the range that you are thinking to protect and locked the
cells, protect the ws

HTH
Regards from Brazil - going to the 6th *
Marcelo

"Jeff" escreveu:

Hi,

Is there a way to protect a range in a worksheet, without protecting the
entire range?

Thanks for your help

--

Dave Peterson