I've a very specific requirement. I'm going to create an excel workbook on the fly (thru program) based on a template. Now, there'll be two set of users, one will have permissions on certain cells whereas the other will have permissions on different set of cells. Also I've certain validations to do while users enter data for which I need to write VBA code.
Now, when the file arrives from a first user, I've to determine (thru the code itself) that user has filled up those very cells only on which it was permitted. Also I need to check that the VBA code that I had in workbook has not been deleted or tampered with.
Can somebody help plz., I'm in dire straits