Excel 2007简单复制粘贴vba不工作在Excel 2016

I've put together what is an audit workbook which is supposed to copy and paste some hidden cells to a data storage sheet that is hidden the collective data in the hidden sheet is then used for KPI reports.I've put together what is an audit workbook whi