Help me stop hurting myself or others

[posfog]

Hi there,
I have a excel sheet that is used by others but they keep on deleting columns for no reason at all.
I have attempted to fix this by locking certain columns and putting a password on the sheet to stop any form of deletion but still allow them to enter data.
The only thing is that is it dosent allow you to copy and past data from another excel sheet which is where we get the data from.


Is there away of stopping people from making phsyical changes to the layout and columns but still allow people to copy and past date a line at a time.

hope this makes sense and thanks in advance.

 

[Logit]

.
Here is one suggestion :

https://it.toolbox.com/question/how...e-event-if-multiple-cells-are-selected-041410



The cells / rows / columns that users are deleting or changing the design .... are more than one person doing the same thing or something similar ?
Consider perhaps the changes they are making are actually beneficial ?

Have you been able to determine why they are making these changes ? Have they stated such or have you asked ?

I'm not saying they are correct in making these changes ....

 

[LlebKcir]

Maybe show them howto HIDE the columns those individuals do not want to see/read?

 

[DanteAmor]

A longer option:


The sheet in question must be protected.
Create a userform with a combo to display open books and a button.


It would work like this, the user would execute the userform and:
- select a book from the combo
- select a book sheet
- select the row to copy
- select a row available at the destination to paste
- Then press the button.


The code would do the following:
- unprotect the sheet
- paste the row
- protect the sheet.