MRichmond
02-18-2014, 01:56 AM
I have a second macro, created and working perfectly in Excel 2003, but now refuses to work in Excel 2010.
The idea behind the workbook is to keep a whole years audits (done every two weeks) in the same file (instead of 26 workbooks).
So on opening the user can either choose to view an existing audit, and in which case they are shown a summary sheet (hiding the home page), with hyperlinks to the audits they can select, and a graph showing their score progression.
If they click on new, it creates a copy of the hidden template question sheet (again hiding the home page), and once a date it added in the relevant cell, the sheet is renamed to the date.
Thats how it worked in Excel 2003.
However in Excel 2010, it appears to rename the home (Landing) page, doesnt hide it, and although it creates a copy of the template this remains hidden.
Any chance some can take a look and see what I need to change to have it work in both Excel 2003 & Excel 2010 (it needs to work in both as not all users have been upgraded to the later version.
I'm attaching a copy of the workbook with the code to help.
The idea behind the workbook is to keep a whole years audits (done every two weeks) in the same file (instead of 26 workbooks).
So on opening the user can either choose to view an existing audit, and in which case they are shown a summary sheet (hiding the home page), with hyperlinks to the audits they can select, and a graph showing their score progression.
If they click on new, it creates a copy of the hidden template question sheet (again hiding the home page), and once a date it added in the relevant cell, the sheet is renamed to the date.
Thats how it worked in Excel 2003.
However in Excel 2010, it appears to rename the home (Landing) page, doesnt hide it, and although it creates a copy of the template this remains hidden.
Any chance some can take a look and see what I need to change to have it work in both Excel 2003 & Excel 2010 (it needs to work in both as not all users have been upgraded to the later version.
I'm attaching a copy of the workbook with the code to help.