M
magmike
Is there a way to make certain cells in a worksheet uncopyable?
For example, if the user selected cells A1:C1 as represented below in Figure 1, selected copy and then pasted into a new row on a different worksheet,and the cells in column C were set to be unable to copy; when they pasted A1:C1, they would get Figure 2.
Figure 1
A1 | B1 | C1
---------------------------------
Denver | Colorado | Complete
Figure 2
A1 | B1 | C1
---------------------------------
Denver | Colorado |
The user would still be able to enter data in the uncopyable cell.
Reasoning:
We currently have 2 worksheets one labeled "orders" and one labeled "potentials". Potential orders are first entered on the potential worksheet where they can be tracked and the different stages of the sales process be recorded and checked off. They are moved to the orders worksheet when they becomeorders and the different stages of fulfillment process are monitored and checked off.
The first 5 columns in both worksheets are exactly the same, but the following few columns differ on each. It's normal for users to accidentally copy the entire row in one sheet and place it in the other. If there is a way tokeep them from copying the last 2 columns when they do it anyway that would solve our problem.
Thanks in advance for your help,
magmike
For example, if the user selected cells A1:C1 as represented below in Figure 1, selected copy and then pasted into a new row on a different worksheet,and the cells in column C were set to be unable to copy; when they pasted A1:C1, they would get Figure 2.
Figure 1
A1 | B1 | C1
---------------------------------
Denver | Colorado | Complete
Figure 2
A1 | B1 | C1
---------------------------------
Denver | Colorado |
The user would still be able to enter data in the uncopyable cell.
Reasoning:
We currently have 2 worksheets one labeled "orders" and one labeled "potentials". Potential orders are first entered on the potential worksheet where they can be tracked and the different stages of the sales process be recorded and checked off. They are moved to the orders worksheet when they becomeorders and the different stages of fulfillment process are monitored and checked off.
The first 5 columns in both worksheets are exactly the same, but the following few columns differ on each. It's normal for users to accidentally copy the entire row in one sheet and place it in the other. If there is a way tokeep them from copying the last 2 columns when they do it anyway that would solve our problem.
Thanks in advance for your help,
magmike