View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
ecav ecav is offline
external usenet poster
 
Posts: 4
Default How do I protect formatting only?

Yes both of those options are selected and I still cannot add data to the
sheet. What am I missing?

"Eric" wrote:

The usual default is to allow users to Select both locked and unlocked cells.
By allowing those 2 options, users can select, add, or delete data without
being allowed to change the formatting of the sheet.

"ecav" wrote:

There's no option for "entering data." How do I allow users to enter data?

"Eric" wrote:

Go to protect sheet and select the options you want to allow users to do.

"ecav" wrote:

I'm trying to prevent the formatting from changing on a worksheet (Excel
2003) while still allowing users to enter data. Is this possible?