Find within Workbook.

M

Matt Carter

Hello, I am trying to Find items in the whole workbook. I have multiple
workbooks in my Office 2003 SP1 (all updates) application. I would like to
have the default of Find Within Sheet - (Ctrl-F and in the Find and Replace
window, the drop down menu for Within: [Sheet, Workbook]).
I can initially select the Find Within Sheet and change it to Workbook, but
after I save (or not) the excel spreadsheet, I have to select Find Worksheet
again, as it has changed to the Sheet (as the default).

Is there a way to change the default from Find within Sheet to Find within
Workbook?

Thank you.

Matt
 
S

SVC

I don't know of a way that you can change this option. However, if you right
click on a sheet tab, you can click "Select All Sheets" and then do your find
(Ctrl+F). If you want to, you can create a macro to do this for you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set focus (and select text) on a text box on a modeless userform? 0
Set the Find and Replace, Options, 'Within' default to Workbook 1
2007 Find_Replace - default on workbook? 0
Finding the right style field in VBA 0
FIND AND REPLACE TEXT ON ALL SHEETS IN ONE ACTION 0
deleting workbooks as i go 4
Finding the proper style field and the numbered paragraph value within the style 0
VBA for Dependents shortcut menu 0

Top