ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unlocked cells become locked on paste (https://www.excelbanter.com/excel-programming/401779-unlocked-cells-become-locked-paste.html)

XP

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.

George

Unlocked cells become locked on paste
 
Hi, XP:

Can you give me an example?

Thanks,


All times are GMT +1. The time now is 06:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com