On Mar 27, 12:32 pm, Greg Lovern wrote:

BTW I've looked at "Allow Users to Edit Ranges" too, but it turns
protection completely off for the affected cells; it doesn't allow me
to protect number formatting (or formatting in general) while allowing
the user to edit the cell contents.

I'm thinking of trapping Ctrl+v and substituting Paste Values for the
affected worksheet, and trying to educate the users (ha ha -- all
25,000 of them with more to come, yeah right...) to paste with the
keyboard instead of with menu or toolbar.

Greg