Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / July 2006

Tip: Looking for answers? Try searching our database.

find and replace

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rdh2378 - 17 Jul 2006 21:52 GMT
When you choose "find" in msexcel 2003, you can choose options, and change
from the default "within sheet" to "within workbook".  Can you modify excel
to have the default option to be to search w/n workbook?
Dave Peterson - 17 Jul 2006 22:21 GMT
Sometimes you can use excel's memory against itself.

Excel remembers the setting from the last edit|replace--whether it was done
manually or via code.  But this is one setting that isn't exposed to code.

So I don't think you can change this behavior/default.

===
If you knew that the options were showing in that dialog, you could use a macro
and sendkeys to select Workbook.

Option Explicit
Sub testme()
   SendKeys "%hw{enter}"
   Application.CommandBars("worksheet menu bar") _
       .Controls("Edit").Controls("Replace...").Execute
End Sub

But this fails if the Options aren't showing on that dialog.

> When you choose "find" in msexcel 2003, you can choose options, and change
> from the default "within sheet" to "within workbook".  Can you modify excel
> to have the default option to be to search w/n workbook?

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.