Trouble with Exporting tab with Buttons to secondary file

atf32

Board Regular
Joined
Apr 13, 2011
Messages
157
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? :confused:
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,109,000
Messages
5,526,186
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top