The proper way to handle this is separate the code from the data. Put the code in an addin that opens and processes the data workbook. That way, they never touch the code workbook.