MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Disabling the Cut function

Posted by Laurent Chauvin on May 15, 2000 2:52 PM

I want to disable the Cut function to avoid that the user corrupts the formulas on a customized worksheet. Does anyone know any simple way to do that ?

Posted by Troy Brockmeier on May 16, 2000 6:10 AM

I don't think you can disable the Cut function, but you could Protect your worksheet. Under Tools, choose Protection.

The other idea would be to have your formulas on another worksheet, and just a reference cell (e.g. =A1) on your customized worksheet.