Disabled macros block VBA code

Hi, I have a set of macro-enabled files that are updated each month. I have another, main file that takes data from those sheets and puts up its list. The VBA code of my main file goes like this:

Please Login or Register  to view this content.

Now, data is extracted from files that have the following VBA code preventing people from opening them unless they enable macros. It also blocks the VBA code in my main file, but I'd rather preserve that part so that people always enable macros.

Please Login or Register  to view this content.

Can I set up the VBA code in my main file so that it does one of two things:

• enables macros in the other files;
• saves the other files as .xlsx and takes data from those, later removes the files?

Why? I can't see that your code needs to run any macros in the other files.

Try changing that to:

Please Login or Register  to view this content.

That is better, yet another error message pops up:

Capture.JPG

Capture.JPG

The sheet data is extracted from is password-protected. Cells with data in question are unlocked if it matters. Is there any way I can leave the protection in place and have the code work?

Which line causes that error?

Yes you may programmatically un-protect the sheet , run the code and then reprotect the sheet (programmatically).

That suggests there isn't a sheet called Protection when the workbook opens.

I don't think so, when I open source files manually, "Protection" sheet is there until I enable macros.

EDIT: No, you're right, I've copied and pasted source files once again and the code works!