Excel/VBA workbook collections

[grntrnr]

I want to open various workbooks but not want to include one of them in the collection - keep it as a separate workbook so that it does not update with all of the other workbooks in the collection. How do I do that?
Thanks

 

[grntrnr]

I meant to indicate that I want to open all of these workbooks from within VBA but want to keep one of them outside the collection

 

[ChrisM]

You could create a custom collection and add only the ones you want, or much easier, just use an if-then to test for file name.

For Each WS in Workbooks
     If WS.Name <> "xx" Then
           'run your code
     End If
Next WS

 

[grntrnr]

I'm not sure I express my problem correctly. I specifically want to keep a workbook and all its sheets from "calculatiing" when another workbook does. I been trying to control that through VBA and macros. Any suggestions?