Hey all. I'm totally stumped on this one.
I've put together a sales dashboard in 2010. It works perfectly. Then I tried to open it up at work in Excel 2013, and all macros work except a few:
- ActiveX toggle buttons
- Macro that brings a chart to the front. Error on this: ActiveSheet.Shapes("WeeklyChart").ZOrder msoBringToFront
- Error on a copy and paste macro. Error: ActiveSheet.Paste
- Worksheet cell change event. (No error, just nothing happens)
But.. there is an entire process of importing sheets of a closed workbook, copying columns, making calculations, appending blocks of data. All done with macros. So I don't get why these aren't working
I know it's something to do with my workbook because I tried these macros on a fresh new Excel 2013 workbook, and they work. Literally copy and pasted all the objects and code to a new workbook, and it was ok. So I don't think it's a problem with excel's settings.
I'm not a programmer, and my code is a hodge podge of bits and pieces I've scraped together from the net. So I'm guessing(hoping) it's something easy I've overlooked.
Am praying for a solution. Thanks.
Bookmarks