#1
|
|||
|
|||
Block Replace
Greetings friends of the forum.
I have macros to avoid copying, paste in my template. In the attempt to prevent a student from copying and pasting information from other documents, I now need to avoid using the replace option as I have verified that it is possible to copy and replace in the template I am preparing The replace code is this: HTML Code:
Sub Replace() Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "s" .Replacement.Text = _ "Possible paragraph with what will be replaced, assuming you will put a letter s to find and replace it" .Forward = True End With Selection.Find.Execute With Selection If .Find.Forward = True Then .Collapse Direction:=wdCollapseStart Else .Collapse Direction:=wdCollapseEnd End If .Find.Execute Replace:=wdReplaceOne If .Find.Forward = True Then .Collapse Direction:=wdCollapseEnd Else .Collapse Direction:=wdCollapseStart End If .Find.Execute End With End Sub I appreciate your support in advance |
#2
|
||||
|
||||
Rather pointless endeavour, IMHO, especially since other methods can be used to replicate content without the need for copying & pasting.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thank you macropod for your answer, .. but for the issue raised ... are you sure there is no way with vba to block the function replace ??
|
#4
|
||||
|
||||
A macro to disable the Find function can be as simple as:
Code:
Sub EditReplace() MsgBox "Go away!": Exit Sub End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Thanks you macropod for the code, this one works perfect !!!
|
Tags |
vba find and replace |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to create a block text and when click on the title of block hide and unhide the block | labasritas@free.fr | Word | 4 | 09-17-2017 01:17 PM |
More than one sum in a block | Verusha Singh | Excel | 1 | 11-15-2016 12:45 AM |
What is this block of text? | nyempire | Word | 5 | 05-26-2016 06:08 AM |
VBA Word - Building Block (AutoText) - Array - Replace Text with Specific Building Blocks | jc491 | Word VBA | 7 | 01-03-2016 10:34 PM |
Block a page | HMS | Word | 2 | 07-12-2013 04:40 PM |