View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Iriemon Iriemon is offline
external usenet poster
 
Posts: 89
Default Locking a format

How do I lock the format but still allow a user to input values into a cell?

I have cells that are unlocked to allow for operator entry but if the
operator copies and pastes from another spreadsheet, the format I've set up
changes to whatever the copied and pasted cell had.

thanks

Irie!