I have a need to run a workbook with a lot of VBE that will open and process information on the sheets in other books. My problem is that the workbooks I have to open also have a lot of VBE on them. Can anyone tell me how I can open workbooks from VBE in one book without Workbook_Open and Workbook_Close subroutines in the books being acted on activating? I guess my question is really how do I open other workbooks with macros disabled from a workbook with macros enabled?

Thanks,

Terry

Hi Terry

Use
Application.EnableEvents = False
' Open here your Workbook
Application.EnableEvents = True



-vemaju