Hi there,

I want a code that checks every excel file that is opened by user will have to check if the excel workbook has a specific sheet and if yes then check Cell value in B5 is "12345". If not then a msg box stating to let user know that the file is invalid.


Note the Sheet the code would be looking is actually hidden and workbook is protected.

appreciate you your help in this regard.