Is there a way to disable pasting formulas from other workbooks?

[bgreeson]

Hello!

I have a situation in which it would be beneficial to disable pasting formulas that originated from a different workbook. For example, I have WB1, you have WB2. I would like copy/paste to work as it normally does with my WB1, but if I copied something from WB2, I would not be allowed to paste it to WB1. Is this possible? I'm fine with pasting values, formats, etc., just not formulas.

[David A Coop]

Before you paste, RIGHT CLICK and select Values Only - you will see an icon with a clipboard with 123 on it.

If you want the formatting to copy, copy as normal, then do the values only copy over the top.

Have I oversimplified your inquiry?

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[bgreeson]

Hi David,

I am familiar with that method. Is there a way for be to disable (entirely) the pasting of formulas? Like make it so that a user simply cannot paste a formula? This can be with vba if needed (and it likely will be). I was thinking something like the following, but it hasn't worked:

Please Login or Register  to view this content.

[Winon]

Hello bgreeson,

When you are pasting any Code, then please use Code Tags.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Thank you,

Regards.

[bgreeson]

Sure, I fixed it

[Winon]

Hi bgreeson,

Thank you for the prompt response.

Have a look here: http://www.asap-utilities.com/excel-...tegorie=9&m=85

and here also: http://www.excelforum.com/excel-prog...worksheet.html

Regards.

[bgreeson]

Perfect! This is exactly the stuff I was looking for. Thank you

[Winon]

Hello bgreeson,

You are welcome.

Glad I could help. If you are satisfied with the solution I had given you, then please mark your Thread as Solved.

Regards.