Allow cell formatting only

[AMK4]

I have a sheet containing a school year calendar on it. I want to
protect it so that they can't change the cell contents, but they can
change the cell formatting. Is there a way to do that? Or am I
looking at having to write an onChange routine that checks every time
if a value has changed and change it back?

 

[sheeba]

Hello,

If You Use tools -> Protection -> Protect sheet and check only Select
Locked cells, Select unlocked cells and Format cells then the user can
only format cells. If you unlock certail cells and check select
unlocked cells only and format cells the the user can only select those
unlocked cells only even for formatting.

Thanks

 

[AMK4]

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.

 

[Guest]

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 TOOLS>PROTECTION 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