Excel 2010 Read Only Conundrum
Posted on 2015-01-16
We have a file that contains a Macro that was written back in 2006. Of course the people/person are no longer with the firm.
When you open the file it looks like there is nothing there, however, when you go to View, Unhide is viewable and when you click on this a window opens with the name of the file.
i.e. the file name in the folder is January 2006.xls and I open it
Excel open but there are no Sheets
Press Unhide and a window opens [Unhide Workbook] with the name of the file January 2006
Press OK and the Sheet is now visible BUT the file is read only
I need to make changes to the Macros within the workbook but cannot save the file as it is Read Only.
Can an Expert explain how to open this as Read/Write please