Protected view File

[JerryH09]

code
Sub test8()
'
' test8 Macro
'


ActiveWindow.ActivateNext
Application.ActiveProtectedViewWindow.Edit
ActiveWindow.ActivateNext
End Sub

Hi Experts,
I have a protected view file and a normal one. I am trying to run the above code from the normal one but I'm getting run time error 91 object variable or with block variable not set. Any ideas how I can fix this?
regards,
JerryH09

 

[JerryH09]

I've found the solution and it is this:
code
Application.ProtectedViewWindows(1).Edit
ActiveWindow.ActivateNext
The problem was that VBA doesn't recognise a protected view workbook as a workbook.
This post can now be closed