I was just wondering, with no particular project in mind, which would make a better security method, in an environment where most of the employees would have some knowledge of Excel ( or VBA).
"A workbook with user and Admin access to selected sheets or two workbooks that have a linked method of writing to each other?"
For example can a workbook have a front end (user sheet/s) and back end ( Admin sheets) and still be reasonably secure? I understand that Excel doesn't have good security as anyone with reasonable knowlege can get around the protection, or can a pair of workbooks have a Parent/ child type relationship so that any attempt to get around the security method on the parent workbook by anyone other than the Admin person can be construed as an attempted security breech?