How do I protect only a group of cells to prevent any change or deletion of
data, and not the entire worksheet? I selected the groups of cells that I
want to protect, and did the protection, but it went ahead and protect
everything in the worksheet, which is what I don't want.

Thank You.

Hi
see your post in Excel.worksheetfunctions

-----Original Message-----
How do I protect only a group of cells to prevent any
change or deletion of
data, and not the entire worksheet? I selected the
groups of cells that I
want to protect, and did the protection, but it went
ahead and protect
everything in the worksheet, which is what I don't want.

Thank You.


.

the default is for all cells to have their locked property set.

Select all the cells and uncheck the locked property.

then select the group of cells and check the locked property

then protect the sheet.

--
Regards,
Tom Ogilvy

"Raymond" wrote in message
...
How do I protect only a group of cells to prevent any change or deletion
of
data, and not the entire worksheet? I selected the groups of cells that I
want to protect, and did the protection, but it went ahead and protect
everything in the worksheet, which is what I don't want.

Thank You.

Hi Raymond

just a note - its not generally necessary to post to more than one group ...

Cheers
JulieD

"Raymond" wrote in message
...
How do I protect only a group of cells to prevent any change or deletion
of
data, and not the entire worksheet? I selected the groups of cells that I
want to protect, and did the protection, but it went ahead and protect
everything in the worksheet, which is what I don't want.

Thank You.

Especially ones for which your question is not really relevant.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

JulieD wrote:

Hi Raymond

just a note - its not generally necessary to post to more than one group ...

Cheers
JulieD

"Raymond" wrote in message
...

How do I protect only a group of cells to prevent any change or deletion

of

data, and not the entire worksheet? I selected the groups of cells that I
want to protect, and did the protection, but it went ahead and protect
everything in the worksheet, which is what I don't want.

Thank You.