ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Locking format (https://www.excelbanter.com/excel-worksheet-functions/45388-locking-format.html)

Terry

Locking format
 
I have a data entry form. I have unlocked the data entry columns, and
protected the sheet. However, users do a fair amount of copy/paste. This
messes up the format. I have written code to re-format that data entry form,
but I think I must be missing something. Is there a way to protect the
format from copy/paste activity?

Thanks,
Terry



All times are GMT +1. The time now is 03:31 PM.

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