Hi AMK4,

Allowing users to select locked cells does not permit changes to the
contents or formatting on protected sheets. Allowing cell formatting does not
permit changes to the cell contents on protected sheets that allow selecting
locked cells. The key words here are "select" and "format". Neither one edits
the contents.

Also, the formatting option is only available via TOOLSPROTECTION in v10
and later. If you need this in xl2000 (for example), you'll have to provide
it through VBA, with the "Userinterfaceonly:=" protection option set to
"TRUE" to allow your code to make changes to locked cells on protected sheets.

Regards, GS
"AMK4" wrote:


Well, therein lies the problem. The client wants every cell locked and
un-selectable, except for those where you actually type in data. The
calendar is no exception, except that they'd like people to be able to
change the formatting of each day-cell, background color, pattern, and
borders.

Allowing locked cells to be selected means they can select -any- cell
on the sheet and change and that's not acceptable. They just want the
date-cells to be able to be selected, and formatting changed, but the
contents of the cell needs to stay as is.

I think I'm back to having to lock everything, unlock the date cells
and then write a sub to run OnChange every time. Ugh, what a pain.


--
AMK4
------------------------------------------------------------------------
AMK4's Profile: http://www.excelforum.com/member.php...o&userid=19143
View this thread: http://www.excelforum.com/showthread...hreadid=508359