Excel/VBA Unique code per file

[mathceleb]

I have a macro which creates a new workbook. The goal is to have any file created from this workbook "tagged" so when we upload the file, the tag is recognized. If the tag does not exist, the upload is rejected.

One idea I had was to use a SHA1 encryption code and plop it into a cell with the hidden format ;;;.

However, if somebody tries to do a Save AS on this file, that code carries over.

Is there a way to tag a file with a certain code where this code disappears if somebody does a SaveAs?

I only want this file tagged if it was directly created from our macro.

 

[Dr. Demento]

One thought is to disable Save As on the "child" workbooks
Disable Save As with VBA

 

[Dr. Demento]

Alternatively, using a Workbook_AfterSave by looking at the workbook name before and after the save and if it's different, delete the code cell and re-save.