Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-10-2023, 11:51 AM
nsackman nsackman is offline How can I disable the checkbox defaulting to wildcard search in Find & Replace? Windows 11 How can I disable the checkbox defaulting to wildcard search in Find & Replace? Office 2010
Novice
How can I disable the checkbox defaulting to wildcard search in Find & Replace?
 
Join Date: Jun 2023
Posts: 2
nsackman is on a distinguished road
Default How can I disable the checkbox defaulting to wildcard search in Find & Replace?


I used the wildcard F&R once, and now it pops up already checked when I do Ctrl H. Or, more correctly, it pops up most of the time and sometimes it doesn't.

I do heavy typing (.docx) and really pay attention to my productivity, so having to uncheck the wildcard box literally 50-60 times a day is quite annoying!

I should add that I would leave it checked as default, but I also constantly use special characters such as ^p for paragraph, and that doesn't work with wildcard checked.

Anyway, I just can't seem to get rid of it so would be extremely grateful if someone has a solution.

Thanks!
Reply With Quote
  #2  
Old 06-10-2023, 04:26 PM
Charles Kenyon Charles Kenyon is offline How can I disable the checkbox defaulting to wildcard search in Find & Replace? Windows 11 How can I disable the checkbox defaulting to wildcard search in Find & Replace? Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

  1. Open Word, without any documents.
  2. Go to the Replace box and click on More so you can see the checkbox.
  3. Uncheck it.
  4. Close Word.
If that does not work, I suspect you have a macro running that runs a Find using wildcards.

When options are checked in this, they remain active at least for the current Word session. That is why, in macros that use any options or set anything in the find and replace dialog, it is important to return everything to the default at the end of the macro.


Here is a macro that will reset the Find/Replace Dialog settings, should you need it.
Code:
Sub FindReplaceDefaultsReset()
'
' Reset Find/Replace dialog to defaults
' Charles Kenyon 2023-06-11
'
    On Error GoTo NoDoc
    With Selection.Find
        .ClearFormatting
        .Replacement.ClearFormatting
        .Text = ""
        .Replacement.Text = ""
        .Forward = True
        .Wrap = wdFindContinue
        .Format = False
        .MatchCase = False
        .MatchWholeWord = False
        .MatchWildcards = False
        .MatchSoundsLike = False
        .MatchAllWordForms = False
    End With
    On Error GoTo -1
    Exit Sub
NoDoc:
    MsgBox "This macro requires an open document."
    On Error GoTo -1
End Sub
Instructions for Installing Macros from Forums or Websites by Graham Mayor, MVP

Last edited by Charles Kenyon; 06-10-2023 at 06:41 PM.
Reply With Quote
  #3  
Old 06-10-2023, 05:21 PM
nsackman nsackman is offline How can I disable the checkbox defaulting to wildcard search in Find & Replace? Windows 11 How can I disable the checkbox defaulting to wildcard search in Find & Replace? Office 2010
Novice
How can I disable the checkbox defaulting to wildcard search in Find & Replace?
 
Join Date: Jun 2023
Posts: 2
nsackman is on a distinguished road
Default

Yes - that's it. Thank you! I have a macro that switches LASTNAME, FIRSTNAME to FIRSTNAME LASTNAME and uses a wildcard F&R. I applied your macro to the end of that and it works like a charm.

Thanks again,
Nancy
Reply With Quote
Reply

Tags
find and replace, wildcard



Similar Threads
Thread Thread Starter Forum Replies Last Post
Search & replace: capture wildcard groups and set a bold formatting alex100 Word VBA 5 02-24-2023 09:39 PM
Wildcard find/replace wildcard question hephalumph Word 1 03-12-2022 12:54 AM
wildcard search and add (not replace) sequential numbers in front equalizer88 Word VBA 4 05-07-2016 08:04 PM
Issue with Wildcard Search and Replace linusthedog Word 3 09-04-2014 03:32 PM
How can I disable the checkbox defaulting to wildcard search in Find & Replace? Wildcard Find and Replace Ulodesk Word 1 06-23-2014 10:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:59 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft