VBA not activating workbook fully

Hi
i am hoping someone can help as this is driving me mad.
I have VBA code that opens a workbook and simply want the user to be able to type in that workbook sheet straight away.
this was working before "upgrading" to 2013.
what happens is the other workbook opens no problem and is in the foreground but when you try and type it gives the error that the sheet is protected (the other workbook when the code is located is protected) so is trying to enter text in the other workbook. i have tried activating the workbook after the open line, selecting the sheet and everything else that i can think of.
i have found that you have to select the other workbook and then go back to the other one to enable you to type into it..
if this is not clear please let me know
thank you in advance

Please Login or Register  to view this content.

That line of code is not your problem. However, WORKBOOKNAME.xlsm should be the active workbook immediately after that line executes. But if you have other code that puts the focus on another workbook, or another sheet in the same workbook, that is not the visible sheet, then you would get the results you describe. It is difficult to analyze the actual cause without the rest of the code after the open statement.

Hi
thanks for the reply.
i have even got to the point of leaving the code to try and resolve it. it is now

Please Login or Register  to view this content.

and still behaving the same

You're opening it "Read Only" and typing into it? It will not save the changes if it is read only. Take the ReadOnly off and see if you get the message.

Yes read only and there is further code in that workbook to email the sheet off (which works fine). it is used by many people and is opened read only to ensure that the users and not saving details into it. The read only has no effect