Disable an OpenWorkbook macro

[brucesw]

I have a macro that searches for text in a number of network filese.

The files have an Open Workbook macro which hides all sheets. I don't want the hide-sheets macro to run when I run my search macro. Anyway to disable macros in a workbook being opened by another macro?

The unhide option apprears to be password protected when I right-click the sheet tabs.

Thanks,

Bruce

 

[Andrew Poulsom]

Like this?

Application.EnableEvents = False

But why is the fact that the sheets are hidden preventing you from searching? You don't have to Select or Activate a worksheet to Find text on it.

 

[brucesw]

Thanks for the quick response.

I should have said that all the data I'm looking for is in the hidden sheets and Find will not show the result from a hidden sheet.

EnableEvents will not prevent me being asked if I want to Enable or Disable Macros on openning the file. If I disable upon openning then all sheets are unhidden and the search will work manually.When I click disable on openning the workbook, it stops my macro too.

It's a little more complicated than i thought. thanks for any help you can offer.

 

[brucesw]

I've found it:
Application.AutomationSecurity = msoAutomationSecurityForceDisable

 

[Andrew Poulsom]

If you put this in your code before the line that opens the workbook:

Application.EnableEvents = False

the Workbook_Open procedure won't run.

 

[brucesw]

Thanks,