Blocking VBA from running

[Martin1962]

Hi,

I have the following issue :

I'm opening an xlsm file called Generator.xlsm, presenting a GUI (Userform) to the user.
At the end, I need to open a second xlsm file called Package.xlsm (basically a template, with some tabs that already contain basis data), and lots of VBA code.
Generator.xlsm writes missing data in Package.xslm and saves it.

Can I block the VBA code in Package.xlsm from running when opened (in background) by Generator.xlsm ?
The idea is to run the VBA code in Package.xlsm only when it's opened with all required data available.

Can I solve this by doing this :

In Package.xlsm (in Workbook_open), check for the presense of a specific tab.
If missing, skip rest of the VBA code.

Thanks for any advise/suggestions.

Martin

 

[Micron]

Loop over all sheets, get the name property of each, test if any name matches and if the sheet name doesn't exist, use Exit Sub after the loop.

 

[RoryA]

Can I block the VBA code in Package.xlsm from running when opened (in background) by Generator.xlsm ?

Yes. Assuming that the code is event code, you can simply disable events using application.enableevets = false before opening the workbook, then re-enable them again afterwards.