Disable Paste In Certain Range of Cells

[jadown]

My spread sheet is setup to populate certain cells based on what the user selects. I want to disable the users ability to paste and anything from another spreadsheet into this range of cells. Also, I want to disable the users ability to insert rows in this range of cells. Is there a way to accomplish this without the user getting an error message when they make their selection to auto populate this certain range?

[kev_]

How does the auto populate work - formula or VBA?
Is it one contiguous range?

[jadown]

It's VBA. That populates Range c26:O31

[kev_]

When they are making their selection to auto-populate, are they physically selecting cells In that range?

[kev_]

Apply sheet protection to protect the range from users, use VBA to lift protection when VBA puts values in those cells, re-apply by VBA
- do you need the code?

Try sheet protection like this:
Unlock all cells
Lock only cells c26:O31
Allow user to do everything apart from inserting and deleting rows and columns
- can get round that if you need with a button and VBA if users are allowed to delete other rows

Protect2.jpg