MAcro does not work when certain cells in a work sheet are protected

Hi

I have this vba code below which is meant to extract a work sheet from a file , paste special the values as they have links and formulas and save it in a path provided with a specific name .

The macro works fine . However I need to protect certain cells as they have formulaes and the user at times inadvertently tend to delete them .

Can someone please help me show a way in which I can run the macro even though cells are protected.

Here is the code below

Please Login or Register  to view this content.

I usually find that the easiest way is to unprotect the sheet before the action and protect it again afterwards.

That means the password will be visible in the code so, in turn, you need to password protect the VBA code so it cannot be (easily) accessed.


Regards, TMS