Prevent cells being dragged on protected sheet

barracudabob

New Member
Joined
Nov 16, 2004
Messages
4
Hi all,

I've searched and searched to no avail for the answer - I'm sure others must have had a similar issue in the past but anyway here goes...

I have a protected worksheet used to calculate employee costs in the business. The managers put in their employee data in some unlocked cells and the calculation of the total cost occurs in a locked area to the right based on certain criteria.

However I come across error message "#REF!" in the calculation if the manager has moved some data to another row.

I can protect against rows being inserted and deleted, but can I prevent data being dragged in this way?

Thanks in advance

Bob
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Sparky

Board Regular
Joined
Feb 18, 2002
Messages
210
Office Version
  1. 2010
Platform
  1. Windows
When using this code is it inserted into a module?
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
24,208
That line goes in what ever routine or module where you want the drag/drop disabled.
A matching line, setting the property to True, would be used to turn it on again.

If you want it as a permenant feature of the sheet or workbook, set the Excel>Options.
 

Sparky

Board Regular
Joined
Feb 18, 2002
Messages
210
Office Version
  1. 2010
Platform
  1. Windows
mikerickson

Thank you.

Sorry for the late reply
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,149
Messages
5,835,683
Members
430,376
Latest member
eeehhhyyy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top