Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default save search settings having all tabs selected-or entire workbook

how do I save settings in a workbook so when i search it selects the entire
workbook vs. an individual sheet of the workbook.
Choices are to right click a tab and select the SELECT ALL SHEETS
or
Use the FIND and go to advanced settings and say search workbook vs. search
sheet.
problem is each time you open the workbook you must go thru this again. how
does one save the settings once you set them?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting Print Settings Across Entire Workbook Nia Excel Discussion (Misc queries) 3 April 3rd 23 01:25 PM
Can Excel settings default to always print entire workbook? evie Excel Discussion (Misc queries) 1 December 15th 06 12:21 AM
Search Entire Workbook Sloth Excel Discussion (Misc queries) 1 October 14th 05 08:56 AM
Search Entire Workbook Sloth Excel Discussion (Misc queries) 0 October 14th 05 05:12 AM
How to Search for word in the Entire Workbook lbbss Excel Discussion (Misc queries) 4 July 4th 05 08:57 PM


All times are GMT +1. The time now is 09:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"