EDIT:

The new files will be accessable by many people and I would like it if the
file was saved as Read Only or saved with the entire sheet protected so they
dont alter any content in the file. Is there an easy way to alter my VBA
code to make this possible rather than going through each file and protecting
them myself?