View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Annette Annette is offline
external usenet poster
 
Posts: 32
Default selecting several open worksheets

I really <miss-spoke in that last post. What I want to know is :

is there any way to change several (5) workbooks that are in the same
file/folder - each workbook only has one sheet and I need to change each
sheet in each file/folder (there are over 400 folders)

"Annette" wrote:

Thank you for the information - I downloaded the addin (and even found
another one I downloaded) - but maybe I just do not know what I am doing
because I can still only make changes one sheet at a time, even when I have 5
open. It only changes the active sheet - does anything change a whole book??

"Jim Thomlinson" wrote:

Ooops... here is the link...

http://www.oaltd.co.uk/MVP/
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

Check out Bill Manville's FindLinks addin as an easy way to find and remove
all links in a workbook...
--
HTH...

Jim Thomlinson


"Annette" wrote:

is there a way to select several open worksheets at a time??

I need to break the links on many worksheets - and do not want to do it
sheet by sheet by sheet by sheet, etc. is there a way to open several at a
time and get them all into the Edit Links window or is there another way to
accomplish the same thing?