OK, I'm still not sure how you plan to make changes to the cell(s) on the sheet because you can't do it manually and there doesn't appear to be any code that will change a value on a cell.
However, to make the code we've given you work, as it stands, or in a modified format, it needs to go in the sheet class module for the sheet where you want to monitor changes. So, in this case, it needs to go in the class module for ClearOutDatainCells, STA High Power ASSY.
An example of changing I7 in code:
This goes in: ClearOutDatainCells, STA High Power ASSY.
And note that the Workbook_Open event code goes in the Workbook module, not a sheet module.
And that code only allows the code to modify Sheet1.
Note that, without cracking the sheet password, I am unable to test the functionality on the actual sheets.
Regards, TMS
Bookmarks