Hi everyone,

I am replying on this thread because I have the same problem. I finished a report, whose charts are automatically updated by excel macros after the user inputs necessary data. I just sent it to my superior, who is going to use this excel file, but some of the macros will not run appropriately on his Excel 2013.

One of the problems is the Activex form buttons. None of the buttons I created work. They do not hide and unhide the cells I programmed them to. I suppose it is related to this post:
http://blogs.technet.com/b/the_micro...-updates-.aspx

The other problem is a macro created to export the charts in image format into a new excel file, so as to facilitate copying and pasting them to ppt. But it runs crazy on excel 2013.

I do not have excel 2013 to debug it, but I could notice what the macro is not able to do by seeing the result. It is not changing worksheets, so it is basically copying and pasting cells in the same worksheet you run the macro. And then it is not separating anything into a new separate file.

So, basically, the following commands are not working on Excel 2013:

This is how I am changing spreadsheets:
Sheets("Example").Select

This is how I am creating worksheets based on a Blank template:
Sheets("Blanksheet part 1").Copy after:=Sheets(Sheets.Count)
Sheets("Blanksheet part 1 (2)").Name = "Part_1"

This is how I am creating the new file with the worksheets the macro just filled with images:
Sheets(Array("Part_1", "Part_2", "Part_3")).Select
Sheets(Array("Part_1", "Part_2", "Part_3"))).Move

As I mentioned, these lines work perfectly on excel 2010, but do not work on Excel 2013. Does anybody know how they should be written to work on Excel 2013?

I appreciate your help.

Thanks a lot