How to identify the originality of the worksheet?

I have a scenario. I want to create a function that when I run on the active worksheet, I can identify whether the worksheet is original. Original means the worksheet is created by a certain author, and after the author made some final changes and send them to other people. Let's say there are 2 sheets created by the author namely 'First' and 'Second'.

Scenario: Now user Leo wants to add a new sheet, 'Third'. When I run the function it will identify the 'First' and 'Second' as original although both sheets have been modified the 'Third' sheet will be identified as 'Not Original'. Also, when Leo copies the sheet 'First' and pastes it in the same workbook as 'Fourth', 'Fourth' will be identified as 'Not Original'.

Is there any way I can achieve this function with VBA code? Or Excel properties for this kind of scenario? Thank you



Read more here: https://stackoverflow.com/questions/67378065/how-to-identify-the-originality-of-the-worksheet

Content Attribution

This content was originally published by ZIV at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: