misiek5510
New Member
- Joined
- May 25, 2021
- Messages
- 38
- Office Version
- 2016
- Platform
- Windows
- Mobile
Hi,
I have very annoying issue. I have a set of unlocked cells and locked cells that calculate things from the unlocked cells (based user input). I'm using absolute references to fix which cells I want to look at, so copy and paste works fine, however the issue occurs when you cut and paste it gives me an !REF error. I'd like to disable cut option as there is no other way to fix this, however the problem is the VBA does not work on the teams / web / sharepoint version of excel, therefore people are messing my sheets up by cutting and pasting. Is there anything I can do apart from endlessly fixing it ?
I have very annoying issue. I have a set of unlocked cells and locked cells that calculate things from the unlocked cells (based user input). I'm using absolute references to fix which cells I want to look at, so copy and paste works fine, however the issue occurs when you cut and paste it gives me an !REF error. I'd like to disable cut option as there is no other way to fix this, however the problem is the VBA does not work on the teams / web / sharepoint version of excel, therefore people are messing my sheets up by cutting and pasting. Is there anything I can do apart from endlessly fixing it ?