ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Disable cut and paste (https://www.excelbanter.com/excel-worksheet-functions/106158-disable-cut-paste.html)

confused

Disable cut and paste
 
Hi,

Is it possible to disable cut/copy/paste in a workbook, while still allowing
the cells to be editable?

My workbook is already password protected, with some of the cells unlocked
and editable.
I want these cells to remain ediable but disable the 'cut' function, because
cutting them upsets a second sheet which refers to these cells

thanks for any help

MartinW

Disable cut and paste
 
Hi confused,

Is this the sort of thing you are looking for?

http://www.ozgrid.com/VBA/disable-cut-copy.htm

HTH
Martin




All times are GMT +1. The time now is 11:04 AM.

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