Working in MS Excel 2010
I use the following VBA code to copy out a tab to a secondary file:
“Workbooks([MainFile]).Sheets(Array("[TabName]")).Copy
Before:=Workbooks([NewFile]).Sheets(1)”
Note: This tab includes code and 3 (Active X) Buttons on the surface that call the code.
PROBLEM: For some unknown reason now, the buttons are no longer being saved to the exported file, even though the rest of the export is as expected. This new issue is only happening when I try to run the code on my system. Other associates have confirmed that this process is working as expected with they run the same code through their systems.
QUESTION: Does anyone know of any settings that I am overlooking that might have tripped accidentally?
I use the following VBA code to copy out a tab to a secondary file:
“Workbooks([MainFile]).Sheets(Array("[TabName]")).Copy
Before:=Workbooks([NewFile]).Sheets(1)”
Note: This tab includes code and 3 (Active X) Buttons on the surface that call the code.
PROBLEM: For some unknown reason now, the buttons are no longer being saved to the exported file, even though the rest of the export is as expected. This new issue is only happening when I try to run the code on my system. Other associates have confirmed that this process is working as expected with they run the same code through their systems.
QUESTION: Does anyone know of any settings that I am overlooking that might have tripped accidentally?
