stop Value Paste on tab

C

charlee63

Board Regular
Joined
Jan 7, 2010
Messages
146
I am having an issue with people value pasting tabs that should keep the formulas on them. So I want to prevent them from value pasting on specific Tabs unless they put tab in new book.

Is this possible?
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Sort by date Sort by votes
One way you could do this is to use the worksheet change event to rewrite all the formula on the worksheet
 
Upvote 0
No need to use VBA.
step 1, set all the cells as unprotected:
1724918179505.png

step 2, select the cells with Fx , then Lock them:
1724918238165.png

step 3, Protect your worksheet:
1724918280203.png
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Solved
VBA to extract info from one tab in several workbooks
Replies
8
Views
313
elpepe1970
E
M
  • Question Question
returning data to another tab
Replies
2
Views
58
mlance617
M
A
  • Question Question
Open, Copy data and Close a workbook based on the names of the tabs in my active workbook
Replies
2
Views
134
Aurore87
A
W
  • Solved
Export Multiple Worksheets from a Workbook based on criteria
Replies
6
Views
155
warleque
W
J
  • Solved
INDEX-MATCH-MATCH help!
2
Replies
15
Views
291
henrik2h
H

Forum statistics

Threads
1,224,802
Messages
6,181,054
Members
453,014
Latest member
Chris258

Share this page

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
Back
Top