Excel 2010 Protected Cells Still Allowing Changes To Be Made

[jsoule]

I have an associate using Office 2010. In Excel they have protected a spreadsheet and allowed custom permissions on a cell range. However, anyone that opens the file can make changes to the cell range. Any ideas?

 

[SkipVought]

hi,

So you...

1) LOCKED the cells in question and
2) PROTECTED the sheet

?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[jsoule]

Yes the spreadshet is protected and they want custom permissions for a cell range inside the spreadsheet.

 

[SkipVought]

http://office.microsoft.com/en-us/e...eet-HA010342979.aspx?CTT=5&origin=HP010342808

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]