Excel Workbook with Macros Running and another new Excel workbook opens causes error message

[nmk34]

I have this workbook with macros running and programmed to minimize or password to close the workbook .This workbook collects data 24 hours with breaks between shifts. if someone minimized it then started a new workbook, Excel popup indicating that this "macro1" not a variable on this new workbook and closes the original workbook with macros. the second new workbook and the popup can not be close except thru Task Manager. is there a work around and maybe limit excel to one instance?

 

[Micron]

I suspect your code uses things like ActiveWorkbook and ActiveSheet - so when it runs the other book/sheet is the active object. That's the risk of using active object references. If not the case I don't know, otherwise perhaps see this for the differences

VBA ActiveWorkbook vs. ThisWorkbook - Automate Excel

In this ArticleActiveWorkbook vs. ThisWorkbookThisWorkbookActiveWorkbookVBA Assumes ActiveWorkbookNew or Opened Workbooks are ActiveThisWorkbook and ActiveWorkbook ExamplesSwitch Active WorkbookMake ThisWorkbook ActiveSet ActiveWorkbook to a VariableClose and Save the Active WorkbookClose the...

www.automateexcel.com

 

[nmk34]

thank you for your response. the data collection software was trying to write to any open excel workbook. i changed the settings to restrict the software to write only a specific workbook and that resolved the problem and no more error. as far as the new Excel instance prevention, i change the excel options under advance, then General to ignore other DDE programs.