S
Steve Jones
Hi
I have been having problems opening a file in Excel XP that has been running
fine in Excel 97.
More by luck than judgement I have discovered that it is related to cell
protection. The worksheet is protected in XL 97 so that the user can only in
certain cells. When I try and open the file in Excel XP it will not even run
the Workbook_Open macro.
If I unprotect the worksheet in XP and then open the file, the file opens as
it should. I have looked at TOOLS,PROTECTION and checked the cells but all
looks OK.
Has anyone come across a similar problem? what was/is the solution?
Thanks Steve
I have been having problems opening a file in Excel XP that has been running
fine in Excel 97.
More by luck than judgement I have discovered that it is related to cell
protection. The worksheet is protected in XL 97 so that the user can only in
certain cells. When I try and open the file in Excel XP it will not even run
the Workbook_Open macro.
If I unprotect the worksheet in XP and then open the file, the file opens as
it should. I have looked at TOOLS,PROTECTION and checked the cells but all
looks OK.
Has anyone come across a similar problem? what was/is the solution?
Thanks Steve