View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Unlocked cells become locked on paste

Using Office 2003 and Windows XP;

I have a form that has some locked cells and some unlocked.

I want to protect the file or sheet (which ever level is right) so that
users can paste special - values into an unlocked area of the sheet (i.e. not
a straight full copy-paste). However, they must not be allowed to insert or
delete rows or columns or make other formatting changes.

How can this be done?

Thanks much in advance.