I have a spreadsheet that has button controls which execute some vba code/macros. It works using Excel 2007 but for some reason it does not work correctly in Excel 2010. There are actually three buttons in particular and I have narrowed the problem down to a line of code:
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
After this line of code runs the button controls on the spreadsheet are disabled. I do not believe this is related to any windows/office updates as I have tested it before and after applying service packs/updates. The file is saved with a .xlsm extension. I haven't found any other issues running the other vba code included in the spreadsheet, just this one line.