Protected View

[JerryH09]

Dear All,
I occasionally get data files scraped from the web. They come in protected view and it is easy to manually enable editing so I can use the data. I would like to use those few manual keystrokes in a macro. The recorded code is:
ActiveWindow.ActivateNext
Application.ActiveProtectedViewWindow.Edit = False
ActiveWindow.ActivateNext


The ActivateNext lines are because the macro is where I want to use the data not the data files themselves but when I run it I get runtime error 91 object variable not set. I can dim Application but I've got no idea how to set it. On error resume next just ignores the application line. Any help would be much appreciated.
Regards,
JerryH09

 

[GR00007]

I'm glad you found a resolution and no apologies are necessary.
There are so many ways of executing Excel and permutations of environments that it is often hard to describe a problem and even harder to offer potential solutions that match what was intended to be asked. The RUM intrinsic (Read user's mind) rarely works.
Welcome to the community of those willing to help.