Change certain values within closed workbook

I've saved this from one of JB's posts and it works well to update some values within a closed workbook, but only if the workbook is not password protected.

Is there anything that can be done in this situation and also to not have to select enable macros for every workbook?

Please Login or Register  to view this content.

Okay this seems to work.

Please Login or Register  to view this content.